Preventing Customization
Hi, Refers to Microsoft Excel 2000. Within my VBA Code I am using the following to disable th CommandBars: 'Ensure the user cannot access any of the Toolbars For Each bar In Application.CommandBars bar.Visible = False Next However the user, when in Excel can right click and choos Customization and put the CommandBars back. Is there any way I ca prevent this happening. TIA Mar -- msippit ----------------------------------------------------------------------- msippitt's Profile: http://www.excelforum.com/member.php...fo&userid=1639 View this thread: http://www.excelforum.com/showthread.php?threadid=27765 |
Preventing Customization
I'm NO fan of tampering with the users UI. But if you have to: use enabled property not the visible property. it'll achieve what you want AND you can simply enable all commandbars at the end of your code. (the user gets his original toolbars back ,with correct positions and correct visibility) -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam msippitt wrote : Hi, Refers to Microsoft Excel 2000. Within my VBA Code I am using the following to disable the CommandBars: 'Ensure the user cannot access any of the Toolbars For Each bar In Application.CommandBars bar.Visible = False Next However the user, when in Excel can right click and choose Customization and put the CommandBars back. Is there any way I can prevent this happening. TIA Mark |
All times are GMT +1. The time now is 06:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com