Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() not running
This simple macro is in the ThisWorkbook area:
Private Sub Workbook_Open() MsgBox ("Macro is running") End Sub But if I open the workbook, nothing happens. If I start the macro in the testing window, everything runs fine (th same result if I copy the macro in a new workbook and open that one). So my conlusion is, Excel is not realising this macro while opening th workbook. I am using Excel 2002 SP2 on Windwos XP. The workbook is an old one first release using Excel 4.0, after that updated several times current size of the template about 2 MB. Has any of you had similar problem with excel events -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() not running
Hi
you have to put this code in your workbook module (named 'ThisWorkbook' in the vBA editor) -- Regards Frank Kabel Frankfurt, Germany This simple macro is in the ThisWorkbook area: Private Sub Workbook_Open() MsgBox ("Macro is running") End Sub But if I open the workbook, nothing happens. If I start the macro in the testing window, everything runs fine (the same result if I copy the macro in a new workbook and open that one). So my conlusion is, Excel is not realising this macro while opening the workbook. I am using Excel 2002 SP2 on Windwos XP. The workbook is an old one, first release using Excel 4.0, after that updated several times, current size of the template about 2 MB. Has any of you had similar problem with excel events. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() not running
Maybe the security is set to High
ToolsMacroSecurity -- Regards Ron de Bruin http://www.rondebruin.nl "Frank Kabel" wrote in message ... Hi you have to put this code in your workbook module (named 'ThisWorkbook' in the vBA editor) -- Regards Frank Kabel Frankfurt, Germany This simple macro is in the ThisWorkbook area: Private Sub Workbook_Open() MsgBox ("Macro is running") End Sub But if I open the workbook, nothing happens. If I start the macro in the testing window, everything runs fine (the same result if I copy the macro in a new workbook and open that one). So my conlusion is, Excel is not realising this macro while opening the workbook. I am using Excel 2002 SP2 on Windwos XP. The workbook is an old one, first release using Excel 4.0, after that updated several times, current size of the template about 2 MB. Has any of you had similar problem with excel events. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open macro not running | Excel Discussion (Misc queries) | |||
Workbook_Open () | Excel Discussion (Misc queries) | |||
Workbook_Open | Excel Programming | |||
Help with Workbook_Open | Excel Programming | |||
Workbook_Open not running when Analysis Tool Pack Add-in selected | Excel Programming |