View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
 
Posts: 49
Default 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
Print
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