Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I posted the other day and got some direction. Thank you Peter Ellis. Now I
need some help with what I found. I found a set of macros that should disable on opening, and enable on closing. The problem is they don't work and I am not literate in macro syntax. I have researched and all I have found says they should work. Here is what I am trying to work with: Private Sub Workbook_Open() Application.CommandBars("Worksheet Menu Bar").Enabled = True Application.CommandBars("Standard").Enabled = False Application.CommandBars("Formatting").Enabled = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.CommandBars("Worksheet Menu Bar").Enabled = True Application.CommandBars("Standard").Enabled = True Application.CommandBars("Formatting").Enabled = True End Sub This is in a standard module. I also nee to encorporate code to stop "copy & Paste from working, or at least the window that come from a right mouse click. Mike Rogers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disabling tool bars | Excel Discussion (Misc queries) | |||
Disable Customize option next to a tool bar from VB | Excel Discussion (Misc queries) | |||
Lost all my menu bars and tool bars | Excel Discussion (Misc queries) | |||
How do I restore my menu and tool bars in Excell? | Excel Discussion (Misc queries) | |||
Worksheets open behind tool bars | Excel Discussion (Misc queries) |