| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto run a macro
Hi,
Can anyone please tell me how to run a macro automatically from the VB-editor when opening the spreadsheet ? Br, Jakob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto run a macro
You can put this in the workbook module:
Private Sub Workbook_Open() 'your code here End Sub or you can put this in a standard module: Sub Auto_open() 'your code here End Sub "Jayjay" wrote in message ... Hi, Can anyone please tell me how to run a macro automatically from the VB-editor when opening the spreadsheet ? Br, Jakob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Auto-run macro after auto-query refresh (Excel2000,sr1) | Excel Programming | |||
| Auto macro | Excel Programming | |||
| Auto macro | Excel Programming | |||
Linear Mode
