Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Built-in items on a menu
The following code disables the File menu on the Worksheet Menubar
CommandBars(1).Controls("File").Enabled = True Ideally I'd like to be able to disable an individual item on the menu e.g. "Print", but I've struggled to get there. Can someone please explain how this is achieved? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Built-in items on a menu
Got it thanks:
With Application.CommandBars(1).Controls("File") ..Controls("Print...").Enabled = False End With "Project Mangler" wrote in message ... The following code disables the File menu on the Worksheet Menubar CommandBars(1).Controls("File").Enabled = True Ideally I'd like to be able to disable an individual item on the menu e.g. "Print", but I've struggled to get there. Can someone please explain how this is achieved? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Built-in items on a menu
Better to use the ID
http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Project Mangler" wrote in message ... Got it thanks: With Application.CommandBars(1).Controls("File") .Controls("Print...").Enabled = False End With "Project Mangler" wrote in message ... The following code disables the File menu on the Worksheet Menubar CommandBars(1).Controls("File").Enabled = True Ideally I'd like to be able to disable an individual item on the menu e.g. "Print", but I've struggled to get there. Can someone please explain how this is achieved? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Built-in items on a menu
Ron,
I should have thought of checking your site. For some reason my code works fine at home (on Win2K/Excel 2003) but not in my work environment (XP/Excel2003) if run in an activate or startup event. Oddly it works in XP if I run the procedure directly using F5. Perhaps switching to the ID will fix it. Thanks for the reply! "Ron de Bruin" wrote in message ... Better to use the ID http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Project Mangler" wrote in message ... Got it thanks: With Application.CommandBars(1).Controls("File") .Controls("Print...").Enabled = False End With "Project Mangler" wrote in message ... The following code disables the File menu on the Worksheet Menubar CommandBars(1).Controls("File").Enabled = True Ideally I'd like to be able to disable an individual item on the menu e.g. "Print", but I've struggled to get there. Can someone please explain how this is achieved? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disabling specific items under tools menu | Excel Programming | |||
Disabling scrollbars for an excel's built-in form (Autoform) | Excel Programming | |||
Help with disabling items in the menu | Excel Programming | |||
Help with Enabling / Disabling Menu Items..! | Excel Programming | |||
Disabling menu items in VBE | Excel Programming |