Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
1) Make sure your Workbook_Open code is in the ThisWorkbook module.
2) Ensure your macros are enabled when you open the workbook. If they aren't, it won't work. 3) Ensure that the events are enabled. I ran into this problem early on. HTH, Barb Reinhardt "Bill" wrote: Using excel 2003 vba When I open a workbook I want it to display a message from itself This will be the first and only workbook user will see Public Sub workbook_open() MsgBox "hello" End Sub Is this possible? By the way the above code does not work If I solve this the rest of my code will be fine Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable Workbooks_Open() Macro when opening from VBA | Excel Programming |