Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Macro referencing wrong form



Hi folks,

I've spent more time than I can spare on this problem, so any help I
receive is already appreciated :)

Okay, I have developed a spreadsheet template, which contains a
toolbar with a button linked to a very simple macro.

The purpose of this macro is to load the 'main menu' form I created,
which greets the user when the spreadsheet is first opened. I've done
this simply by placing 'frmFirst.Show' in the macro.

All works, until I create an .xls file from the template. Whenever the
button is pressed, and subsequently the macro initiated, it ALWAYS
loads the 'main menu' form from the first .xls file ever created,
whether it is open or not.

If the first .xls created is no longer in existence, I get an error
message telling me that the file can't be found.

I can only assume that there is a reference error happening here, but
for the life of me I cannot figure out what to chage or where to
change it.

Any help is appreciated, and I hope I've been specific enough....

Cheers,
VanIkyn

[EMAIL PROTECTED]



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.