Can I disable custom toolbar building?

[Mr Nick]

I have a worksheet that has all toolbars removed and a custom toolbar inserted to allow only the options I want to be used. This custom toolbar has been locked using msoBarNoCustomize to stop people adding buttons to it. You can however still create new toolbars which defeats all the measures I have taken to secure my sheet.

Is it possible to remove this backdoor - preferably by removing the Customize button from the shortcut menu when right clicking the toolbar.

[Ivan F Moala]

On 2002-04-08 01:02, Mr Nick wrote:
I have a worksheet that has all toolbars removed and a custom toolbar inserted to allow only the options I want to be used. This custom toolbar has been locked using msoBarNoCustomize to stop people adding buttons to it. You can however still create new toolbars which defeats all the measures I have taken to secure my sheet.

Is it possible to remove this backdoor - preferably by removing the Customize button from the shortcut menu when right clicking the toolbar.

Try;

application.commandbars("Toolbar List").enabled = false

[Mr Nick]

Thanks Ivan.

[Dave Hawley]

Hi Mr Nick


Here is the link I think you need.

http://support.microsoft.com/default...;en-us;Q170563