Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open event not working
I have wrote a couple of routines in the Workbook_Open event
procedure, in workbooks that contain other routines in normal modules aswell. Everything works on my machine ok. When a friend goes into these workbooks he can fire the procedures in normal modules ok, but when he opens the workbook the Workbook_Open procedure doesn't fire for him. Any ideas?? J |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open event not working
I'll try this tomorrow Chip,
I'll place this line at the start of the workbook_open procedure & I'll place it at the the end of the other normal modules in the workbook I'll report back as to whether this works Cheers J "Chip Pearson" wrote in message ... Jason, It is possible that the EnableEvents property got set to False. Use the following line of code to restore the property to True. Application.EnableEvents = True -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "jason" wrote in message om... I have wrote a couple of routines in the Workbook_Open event procedure, in workbooks that contain other routines in normal modules aswell. Everything works on my machine ok. When a friend goes into these workbooks he can fire the procedures in normal modules ok, but when he opens the workbook the Workbook_Open procedure doesn't fire for him. Any ideas?? J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open event does not run on Outlook attachment | Excel Discussion (Misc queries) | |||
workbook_Open event Procedure | Excel Discussion (Misc queries) | |||
workbook_Open event Procedure | Excel Discussion (Misc queries) | |||
Workbook_Open() Event | Excel Discussion (Misc queries) | |||
Workbook_Open not working | Excel Discussion (Misc queries) |