Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub Workbook_Open and BeforeClose not working
I have created the following macros in my workbook:
Sub Workbook_Open() Application.CommandBars("Tools").Controls("Protect ion").Enabled = False End Sub Sub Workbook_BeforeClose(Cancel As Boolean) Application.CommandBars("Tools").Controls("Protect ion").Enabled = True End Sub Neither of these macros is working. When I open the file, the Tools Protection is still enabled. If I run a separate macro to disable the protection, then save the file and exit, the protection is still disabled. I am running Excel 2003. The macros are in Module 1 of the worksheet project. Any help would be very much appreciated!!!! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open not working? | Excel Programming | |||
Workbook_Open() Not working | Excel Programming | |||
Workbook_Open not working | Excel Discussion (Misc queries) | |||
Workbook_Open and Workbook_BeforeClose not working | Excel Programming | |||
Workbook_Open event not working | Excel Programming |