| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code changed Excel settings for all worksheets
I used the following vb code in a file to disable a the menu items. Now
every time I open Excel the Menu is not there. Green around the gills with vb. What did I do wrong? Application.CommandBars.("Worksheet Menu Bar").Enabled = False |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB code changed Excel settings for all worksheets
Hi JenniferMc
Open Excel Alt-F11 Insert module Paste the sub Alt-Q Alt-F8 Select test Run Sub test() Application.CommandBars("Worksheet Menu Bar").Enabled = True End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "JenniferMc" wrote in message ... I used the following vb code in a file to disable a the menu items. Now every time I open Excel the Menu is not there. Green around the gills with vb. What did I do wrong? Application.CommandBars.("Worksheet Menu Bar").Enabled = False |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB code changed Excel settings for all worksheets
Can this code run when the document is closed so that only the specific
workbook is impacted? "Ron de Bruin" wrote: Hi JenniferMc Open Excel Alt-F11 Insert module Paste the sub Alt-Q Alt-F8 Select test Run Sub test() Application.CommandBars("Worksheet Menu Bar").Enabled = True End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "JenniferMc" wrote in message ... I used the following vb code in a file to disable a the menu items. Now every time I open Excel the Menu is not there. Green around the gills with vb. What did I do wrong? Application.CommandBars.("Worksheet Menu Bar").Enabled = False |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB code changed Excel settings for all worksheets
Sure
Use this events in the thisworkbook module 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 -- Regards Ron de Bruin http://www.rondebruin.nl "JenniferMc" wrote in message ... Can this code run when the document is closed so that only the specific workbook is impacted? "Ron de Bruin" wrote: Hi JenniferMc Open Excel Alt-F11 Insert module Paste the sub Alt-Q Alt-F8 Select test Run Sub test() Application.CommandBars("Worksheet Menu Bar").Enabled = True End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "JenniferMc" wrote in message ... I used the following vb code in a file to disable a the menu items. Now every time I open Excel the Menu is not there. Green around the gills with vb. What did I do wrong? Application.CommandBars.("Worksheet Menu Bar").Enabled = False |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB code changed Excel settings for all worksheets
"JenniferMc" wrote: I used the following vb code in a file to disable a the menu items. Now every time I open Excel the Menu is not there. Green around the gills with vb. What did I do wrong? Application.CommandBars.("Worksheet Menu Bar").Enabled = False I learned the hard way that those code lines become the ongoing defaults for Excel. I cured it by running a macro wherein the codes end in "=True". The problem is that any users that you gave your macros to now have the same problem of a missing menu. You'll have to send them the repair macro. Regards Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| my excel settings changed and i have only 1 instance running. | Setting up and Configuration of Excel | |||
| Charts: Can the Default settings be changed | Charts and Charting in Excel | |||
| Can AutoSave's default settings be changed to one's preference? | Excel Discussion (Misc queries) | |||
| Settings are changed when opening workbook on a different computer | Excel Discussion (Misc queries) | |||
| Restoring Excel menu bar settings that were changed by code | Excel Programming | |||
Hybrid Mode
