Hello, I have a wb with built in commandbars and toolbars customized on
the activate wb event and resetted on the deactivate wb event. I'ld like
to know if it is possible to prevent the user to disable the macro at
the start of the wb and to customize the menus/toolbars. Moreover I can
disable a commandbar (for example "Tools") getting it grayed on the
worksheet menubar, but I'm not able to hide it completely.

I have used this

Application.CommandBars("Tools").enabled=False

and these

Application.CommandBars("Tools").enabled=False
Application.CommandBars("Tools").visible=False

but with these I'm able to hide only the toolbars (e.g. Standard tb).

Emiliano


--
eggpap

Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=13064