View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default 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?