| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Option from tools in Menu bar
Is there visual basic that will allow me to disable "options" under "tools"
from the menu bar? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Option from tools in Menu bar
Hi
Try this Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = False More info here http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Qaspec" wrote in message ... Is there visual basic that will allow me to disable "options" under "tools" from the menu bar? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Option from tools in Menu bar
That works perfect thanks! Merry xmas
"Ron de Bruin" wrote: Hi Try this Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = False More info here http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Qaspec" wrote in message ... Is there visual basic that will allow me to disable "options" under "tools" from the menu bar? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Option from tools in Menu bar
Just wondering....if I wanted to place a command button on sheet1 to restore
the options menu item is this possible? I tried this: Private Sub OptOn_Click() Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = True End Sub But nothing happens. "Ron de Bruin" wrote: Hi Try this Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = False More info here http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Qaspec" wrote in message ... Is there visual basic that will allow me to disable "options" under "tools" from the menu bar? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Option from tools in Menu bar
Use
ActiveCell.Activate Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = True -- Regards Ron de Bruin http://www.rondebruin.nl "Qaspec" wrote in message ... Just wondering....if I wanted to place a command button on sheet1 to restore the options menu item is this possible? I tried this: Private Sub OptOn_Click() Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = True End Sub But nothing happens. "Ron de Bruin" wrote: Hi Try this Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = False More info here http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Qaspec" wrote in message ... Is there visual basic that will allow me to disable "options" under "tools" from the menu bar? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep macros from being ran under the tools option in the menu bar | Excel Discussion (Misc queries) | |||
| Disable macro selections under tools menu | Excel Discussion (Misc queries) | |||
| Add to My Places Option Tools Menu | Excel Discussion (Misc queries) | |||
| my tools menu does not have Letter and Mailings option | Excel Worksheet Functions | |||
| Disable Control in Tools Menu | Excel Programming | |||
Linear Mode
