Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have seen several topics on this, but no real good answer. One
solution suggested remove the toolbars altogether. Unfortunately, I want to keep my formatting and standard toolbars on the screen. I've locked all the other ways to customize a toolbar. If I could remove this option, I would be set. I've tried several things in VBA without any luck. It makes me wonder if it's actually a command bar property that can be turned off. Anyone know??? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
One other note:
Application.CommandBars("Toolbar list").Enabled = False still allows the "customize" menu to appear. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Travich,
Would this work for you? Application.CommandBars.DisableCustomize=True This affects all commandbars in the collection. You should remember to set it to False when your project closes. HTH Garry |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I failed to mention that my suggestion only applies to v10 and later.
Otherwise, you may have to iterate the commandbars collection and set the ..Protection property for each bar to msoBarNoCustomize. Regards, Garry |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Gary, that worked great and I found this solution a few days
ago. I've been able to learn how to completely control EVERYTHING through locking this down and customizing commandbars. I'm surprised to find that even a right click falls under command bars. It's been a good learning experience. :) GS wrote: Hi Travich, Would this work for you? Application.CommandBars.DisableCustomize=True This affects all commandbars in the collection. You should remember to set it to False when your project closes. HTH Garry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there any plan to incorporate an "Excel 2003 Menu type" structu | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook | Excel Programming | |||
Can I "customize" an autoformat report for a Pivot Table in Excel | Excel Discussion (Misc queries) | |||
inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions |