LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 176
Default How to prevent resetting of Excel Toolbars

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


"Flaffi" wrote in message
m...
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH ROB Excel Discussion (Misc queries) 2 April 2nd 07 01:13 PM
Excel 2003 color resetting problem Sunny Excel Discussion (Misc queries) 0 December 19th 06 12:28 AM
resetting excel to default values asiffaleel Excel Discussion (Misc queries) 1 May 3rd 06 09:27 PM
Excel attachments change my customized toolbars. Can I prevent? MarJean Excel Discussion (Misc queries) 0 April 28th 06 01:32 PM
excel calendar year resetting 2005 2006 whowatwerwyhow Excel Discussion (Misc queries) 1 May 16th 05 12:29 PM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"