| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding other bars disabled ???
Hi all
I've made an application (with my own commandbars) in Excel 9. I've just upgraded Excel 10 and I find out that there is a posssibility to add other commandbars, commandbuttons by clicking on the control at the end of a commandbar. I need to disable this possibility ... Thanks Fero |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding other bars disabled ???
Chip Pearson posted this:
You can use Conditional Compilation combined with CallByName to do what you want. For example, #If VBA6 Then If CInt(Application.Version) 9 Then ' Excel 2002 or 2003 CallByName Application.CommandBars, "DisableCustomize", VbLet, True Else ' Excel 2000 End If #Else ' Excel 97 #End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com === In this similar thread: http://groups.google.com/groups?selm...GP11.phx. gbl wrote: Hi all I've made an application (with my own commandbars) in Excel 9. I've just upgraded Excel 10 and I find out that there is a posssibility to add other commandbars, commandbuttons by clicking on the control at the end of a commandbar. I need to disable this possibility ... Thanks Fero -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding different value error bars to each column of the SAME serie | Excel Discussion (Misc queries) | |||
| Adding individual error bars | Charts and Charting in Excel | |||
| Adding Trendline To Just Some of the Bars in Chart | Charts and Charting in Excel | |||
| adding vertical bars to an embedded chart using VBA | Excel Discussion (Misc queries) | |||
| adding scroll bars to a chart | Charts and Charting in Excel | |||
![Dave Peterson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
