Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default lock customize bar

I built my own Menu Bar and use:
Application.CommandBars("Standard").Enabled = False
to avoid unwanted changes. But right click on menu bar still let users
to add buttons and customize it.
Any help on how to get rid of "customize" option, or at least lock it
out.
Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 226
Default lock customize bar

You can use the .Protection property to decide what you want the users to do
or not to do with the commandbar.

--
Regards,

Juan Pablo González

"Daniel" wrote in message
om...
I built my own Menu Bar and use:
Application.CommandBars("Standard").Enabled = False
to avoid unwanted changes. But right click on menu bar still let users
to add buttons and customize it.
Any help on how to get rid of "customize" option, or at least lock it
out.
Thanks!



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default lock customize bar

Perfect. Thnx!



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply
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 do I turn scroll lock off (2007 excel)? No scroll lock key Cameron A Perth Excel Discussion (Misc queries) 1 September 18th 09 05:46 AM
How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) Rick-cel Excel Discussion (Misc queries) 2 August 5th 09 06:45 PM
how do I undo the scroll lock, thscroll lock button does not work scroll lock Excel Discussion (Misc queries) 3 July 19th 08 10:17 PM
I have lock a wookbook but one cell does not want to lock it Mimi Excel Discussion (Misc queries) 2 January 21st 07 10:59 PM
I have lock a wookbook but one cell does not want to lock it Mimi Excel Discussion (Misc queries) 1 January 21st 07 09:44 AM


All times are GMT +1. The time now is 08:22 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"