How can I prevent users from deleting an Excel toolbar from a work
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
"BillBreck" wrote in message ...
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?
|