How to prevent resetting of Excel Toolbars

  • Thread starter Thread starter Flaffi
  • Start date Start date
F

Flaffi

Hello !

I am using Excel to create a tool based on thousands of data elements.

To use the tool customized Menu and Toolbars are created and all
standard Excel Menu bars are deactivated, but can be reset by using
customize and reset the specific menu bar.

How is it possible to prevent that a menu bar can be reset by the user
??

Thank You for your Help !

Bye,
Thimo
 
Thimo,

You can't prevent the user from customizing or resetting their
commandbars.

What you can do is create your commandbar and hide the other bars each
time your workbook is opened, activated, or when some other event
occurs.

Remember to destroy your commandbar and unhide the others when your
workbook is closed.

There is a lot of example code available in the newsgroup archives on
Google.

HTH,
Bernie
 
Back
Top