Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restricting use of menus and toolbars
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) | |||
Custom Menus and Toolbars | Excel Discussion (Misc queries) | |||
Excel Menus/Toolbars missing | Excel Discussion (Misc queries) | |||
Missing menus and toolbars | Excel Discussion (Misc queries) |