If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Disabling use of menu items - How?
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 click 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 |
Thread Tools | |
Display Modes | |
|
|