Lock Commandbars

  • Thread starter Jean-pierre Hermans
  • Start date
J

Jean-pierre Hermans

Hello,


Is it possible to lock a selfmade commandbar?
So that the users of my workbook cannot delete them!


Greetz.
 
J

Jim Cone

Jean-pierre,

This may do the trick...
Set SelfMade = Application.CommandBars.Add(...
SelfMade.Protection = msoBarNoCustomize

This doesn't hurt either...
Application.CommandBars("Toolbar List").Enabled = False

Regards,
Jim Cone
San Francisco, CA
 
Top