View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
msippitt msippitt is offline
external usenet poster
 
Posts: 1
Default 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