How can I prevent users from deleting an Excel toolbar from a work

[BillBreck]

I've written some VBA code that creates a custom toolbar within an Excel 2000
workbook when it is opened. I would like to protect the toolbar so that it
can't be deleted, but don't see anything that will work. Any suggestions?

 

[Jim Cone]

Bill,

Here is a suggestion...

Set MyCustomToolBar = Application.CommandBars.Add(...
MyCustomToolBar.Protection = msoBarNoCustomize

This doesn't hurt either...
Application.CommandBars("Toolbar List").Enabled = False
(Reset this on closing the workbook)

Regards,
Jim Cone
San Francisco, USA