Lock Commandbars
 

Hello,


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


Greetz.

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.

Lock Commandbars
 

Jim Cone wrote:

Lock Commandbars

Jim,

Thank you for the good tips.

Regards.