Prevent user from customizing menus in Excel.

[Guest]

Hi,

How do I prevent users customizing Menus and Toolbars in Excel 2000, XP and
2003.
I want to disable some options. But also want to prevent the users re-adding
them to the toolbars.

Regards
Tim

 

[Guest]

Hi,

I have noticed other entries on the newsgroup which try to address this
problem.

My only outstanding issue is how to pevent the Double Clicking of the menu
bar to display the customize dialog in Excel 2000.

 

[Yan-Hong Huang[MSFT]]

Hi Tim,

Based on my understanding, now the question is: how to prevent the double
clicking of the menu bar from displaying the "Customize" dialog in Excel
2000? Please correct me if there is any misunderstandings.

Generally speaking, we can accomplish it by assign doubleclick to a dummy
macro:

Application.OnDoubleClick = "MacroDouble"
Sub MacroDouble
A=1
End sub

Besides, we may also need to turn off the right click in the same location
if you want to prevent user from customizing menus:
CommandBars("Toolbar List").Enabled = False

There is a good KB article on it:
"OFF97: How to Prevent Customization of Menus and Toolbars"
http://support.microsoft.com/default.aspx?scid=kb;en-us;170563
The CommandBars object model allows you to turn off (disable) the Toolbars
shortcut menu. This simplifies preventing others from changing the toolbars
and menus of a custom application that you develop with Microsoft Office.

You may also apply the method in it. Please let me know whether the above
is useful. If there is any question, please feel free to post here and we
are here to support you at your convenience.

Have a good day.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://msdn.microsoft.com/subscriptions/managednewsgroups/

This posting is provided "AS IS" with no warranties, and confers no rights.