Opening Macro on opening excel file? 
Author Message
 Opening Macro on opening excel file?

I need to run a macro called "loadsLists" when I open a File called
"Master1.xls"
The macro "loadsLists" is a userform that supplies the operator with
various drop down combos
so that he can choose the way the program/s will run.

Thanks in advance Rad



Mon, 18 Dec 2000 03:00:00 GMT  
 Opening Macro on opening excel file?
If you name the macro Auto_Open, Excel will automatically run it when you open
up the file. Works on Excel5 and Excel95 anyway, havn't tried it in 97 yet.


Sat, 30 Dec 2000 03:00:00 GMT  
 Opening Macro on opening excel file?
Yep, it works there too!

Fred Scharmann
Avon, Ohio
----------------------

Quote:
>If you name the macro Auto_Open, Excel will automatically run it when you
open
>up the file. Works on Excel5 and Excel95 anyway, havn't tried it in 97 yet.



Sat, 30 Dec 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. when opening an excel file programatically, the newly opened file's Auto_Open macro runs

2. Excel opens up files when you open Excel

3. Excel file opened in Word, will now not open in Excel

4. Open Spreadsheet from File Explorer versus from Excel w/ File/Open

5. opening html file programmatically in an opened excel file

6. Unable to open XSL file when TXT file already opened in Excel

7. Opening an excel file through a form/running excel macros through access

8. auto-running excel macros as soon as you open an excel file

9. excel -97 can't open excel -95 files if they include macros

10. Opening an excel file through a form/running excel macros through access


 
Powered by phpBB® Forum Software © phpBB Group