vba toolbox displays on userform

[Paul]

Can anyone tell me why on some userforms when they are
displayed the vba toolbox is also displayed on top of the
form.

How do I stop this happeneing it doesnt do it on all
forms just odd ones.

Thanks in anticipation.

Paul

 

[Mark Tangard]

Hi Paul,

The "clean" answer is, it'll display if macro security is
set to high, because all it's allowed to do is enter design
mode. However, I've found that answer inadequate in some
cases, and I don't know the real explanation either. What
I've done is put:

CommandBars("Control Toolbox").Visible = False

at the end of the form's Initialize event. It's inelegant
as hell but seems not to damage anything. Maybe someone
else will clue us in.

 

[Paul]

Mark

Thanks for this.

Paul

-----Original Message-----
Hi Paul,

The "clean" answer is, it'll display if macro security is
set to high, because all it's allowed to do is enter design
mode. However, I've found that answer inadequate in some
cases, and I don't know the real explanation either. What
I've done is put:

CommandBars("Control Toolbox").Visible = False

at the end of the form's Initialize event. It's inelegant
as hell but seems not to damage anything. Maybe someone
else will clue us in.

--
Mark Tangard, Microsoft Word MVP
Please reply only to the newsgroup, not by private email.
Note well: MVPs do not work for Microsoft.
"Life is nothing if you're not obsessed." --John Waters



.