| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding tools/options
Is there a way to hide the menu item tools/options from end users?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hiding tools/options
Run this in the workbook activate and in the deactivate set it to True
Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = False See also http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "gfkbob" wrote in message ... Is there a way to hide the menu item tools/options from end users? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disabling hiding rows | Excel Discussion (Misc queries) | |||
| clicking TOOLS/OPTIONS gives me error msg "cannot access dir D:/" | Excel Discussion (Misc queries) | |||
| Hiding Column and Row Bars. | Excel Discussion (Misc queries) | |||
| Hiding Formula's | New Users to Excel | |||
| Hiding Personal.xls Requires Exit Twice | Excel Worksheet Functions | |||
Hybrid Mode
