View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Lock Commandbars

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

"Jean-pierre Hermans" wrote in message ...
Hello,


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