| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autoexec macro to run on opening the spreadsheet
How do I make a macro that starts automaticaly upon the file opening?
On other applications you could save the macro with the file name autoexec and this would work, but how do you do this with Excel ??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autoexec macro to run on opening the spreadsheet
Hi,
Press Alt + F11. Select this workbook then enter Private Sub Workbook_Open() 'Your code here End Sub Link should help to http://www.mcgimpsey.com/excel/modules.html VBA Noob Lee wrote: How do I make a macro that starts automaticaly upon the file opening? On other applications you could save the macro with the file name autoexec and this would work, but how do you do this with Excel ??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autoexec macro to run on opening the spreadsheet
Private Sub Workbook_Open()
'Opening Your code here End Sub HTH Lou "Lee" wrote: How do I make a macro that starts automaticaly upon the file opening? On other applications you could save the macro with the file name autoexec and this would work, but how do you do this with Excel ??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two Questions: R1C1 and stop text number converting to data | Excel Discussion (Misc queries) | |||
| spreadsheet has outgrown the macro! | Excel Discussion (Misc queries) | |||
| how do I email amacro? | Excel Worksheet Functions | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| Run a macro when opening a spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
