Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorkBook Open & Right Before Close Subs Not being called
This Sub is no longer working. Also the one I call when I load the file is
not working either. Private Sub Workbook_BeforeClose(Cancel As Boolean) 'this builds the menus that are added when this workbook is loaded Application.CommandBars("Worksheet Menu Bar").Controls("&Activity").Delete End Sub For loading: Private Sub Workbook_Open() MsgBox ("going to start adding menus") I recently protected my macros from viewing: Tools VBA Protection. Would this have any affect? Ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorkBook Open & Right Before Close Subs Not being called
When I removed the protection it worked! So what do I do as I wish to have
my cake and eat it too. I want the protection and I want the menus to be added and removed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open event not called when workbook forced to re-open in read-only mode. | Excel Programming | |||
Open workbook on close | Excel Programming | |||
When I open a workbook, another one called Book1 is also opened. W | Excel Discussion (Misc queries) | |||
Called subs versus functions | Excel Programming | |||
how to make subs/procs can only be called from within the workbook they belong to? | Excel Programming |