Userform edit ToolBox open along as Useform Loads - Is this a Known issue?

[pedie]

Hi, My Userform edit ToolBox open along as Useform Loads - Is this a Known issue?Please let me know if there is a way to take care of this problem...

Thanks in advance

 

[Jaafar Tribak]

Hi, My Userform edit ToolBox open along as Useform Loads - Is this a Known issue?Please let me know if there is a way to take care of this problem...

Thanks in advance

Not sure why that happens but you could try this :

Private Sub UserForm_Activate()
    ShowToolbox = fmModeOff
End Sub

 

[Hermanito]

I have seen this sometimes, but only when I had the VBE window open as well. I have never seen it when only Excel is open.
Am I right in assuming you had this happen while debugging something and you had the Visual Basic Editor open?

 

[pedie]

Not sure why that happens but you could try this :

Private Sub UserForm_Activate()[/FONT]
[FONT=Courier New]    ShowToolbox = fmModeOff[/FONT]
[FONT=Courier New]End Sub[/FONT]
[FONT=Courier New]

Jaafar and Hermanito thanks guys for helping...
The editor window is not on...this has happen to me in few of my tool, few times...not everytime...So i thought would be good to post here bout it...
I'll use your code Jaafar, in case it happens again...
Thanks again guys!