Thread: Toolbar lockout
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Toolbar lockout

You can use this Brian

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Brian Matlack" wrote in message
news:Brian.Matlack.1xku6l_1130443522.8443@excelfor um-nospam.com...

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!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=479921