Adding other bars disabled ???

G

Guest

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
 
D

Dave Peterson

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/[email protected]
 
Top