![]() |
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 |
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 |
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