ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Toolbar lockout (https://www.excelbanter.com/excel-programming/344040-toolbar-lockout.html)

Brian Matlack[_18_]

Toolbar lockout
 

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


Ron de Bruin

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




Brian Matlack[_19_]

Toolbar lockout
 

Thanks Ron Works Great!!


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



All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com