protect custom toolbar from being changed ?

[dmills]

as the subject suggests... is it possible and if so, how ?

 

[Ron de Bruin]

Hi dmills

Do you create the toolbar with code ?

 

[dmills]

nope. created it using the customize function in the tools menu.

i need to restrict what the users can do in the spreadsheet, so i figured
make a custom toolbar with just what they will need to do their work and then
hide the menu bar to keep people away from the functions they dont need.

easy enough, but he toolbar can still be edited and i cant figure out how to
lock it down

any help appreciated, and thanks in advance.....

 

[Ron de Bruin]

Sorry I always do it with code

You can run this

Application.CommandBars.DisableCustomize = True

See also
http://www.rondebruin.nl/menuid.htm

 

[dmills]

Outstanding....thats exactly what I was looking for

thanks bunches