Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi once again,
This code works good save for one problem. When I exit Excel, my menu's don't return. As you see I have tried both the "Deactivate" and the "Close" events but I'm missing something. (All of these are in the workbook part). Private Sub workbook_open() Sheets("Sign").Select End Sub Private Sub Workbook_Activate() Application.CommandBars("Worksheet Menu Bar").Enabled = False End Sub Private Sub Workbook_Deactivate() Application.CommandBars("Worksheet Menu Bar").Enabled = True End Sub Private Sub Workbook_Close() Application.CommandBars("Worksheet Menu Bar").Enabled = True End Sub -- Thanks ....Kev... ....kev... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming |