I have a custom toolbar 'Calc Tools' which I do not want to be customized by users of my sheet. All other toolbars are removed from the sheet.
Application.CommandBars("Calc Tools").Protection = msoBarNoCustomize does not work
myBar.Protection = msoBarNoCustomize does not work
Can anybody help on this one?
Application.CommandBars("Calc Tools").Protection = msoBarNoCustomize does not work
myBar.Protection = msoBarNoCustomize does not work
Can anybody help on this one?