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

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