Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I remove toolbars and specific menus items to restrict use?
I have an application workbook where I need to restrict
actions that can be done by the user, specifically I need to remove some or all of the toolbars and Menubar items and also disable the use of the right ckick to customise and switch on or off toolbars etc. All that I want to be visible and enabled are the following: On the Menu Bar: File Tools Help Close Protection About Microsoft Excel Save Print Preview Exit Also I do not want any of the toolbars visible or enabled. Can anyone give me guidance as to the code or macros for how this can be done, it should be set only when the workbook is opened and active, and should be reset to the users normal settings when the workbook is closed or not active. Thank you in advance for any assistance. Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Menus and Toolbars | Excel Discussion (Misc queries) | |||
Cannot unhide toolbars/menus | Excel Discussion (Misc queries) | |||
Remove Toolbars and Menus but keep print button | Excel Discussion (Misc queries) | |||
Custom Menus and Toolbars | Excel Discussion (Misc queries) | |||
Missing menus and toolbars | Excel Discussion (Misc queries) |