Toolbar lockout

[Brian Matlack]

Hi!
My workbook will be accessed through the web site (read only) by
customers. I have a custom menu bar to elliminate the menus. Is there a
way to stop them from accessing the toolbar menu (right-clicking the
menu bar)?
Thanks!!

 

[Ron de Bruin]

You can use this Brian

'Disable right clicking on the worksheet menu bar and other bars
Application.CommandBars("Toolbar List").Enabled = False

 

[Brian Matlack]

Thanks Ron Works Great!!