vbModeless does not work why? Pls help!

[pedie]

<TABLE style="WIDTH: 539pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=719 border=0><COLGROUP><COL style="WIDTH: 539pt; mso-width-source: userset; mso-width-alt: 26294" width=719><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 539pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=719 height=17>When I open my workbook, Userform shows but not Modeless…I can't click on the background!</TD></TR></TBODY></TABLE>

[SIZE=1]Private Sub Workbook_Open()[/SIZE]
[SIZE=1]UserForm1.Show vbModeless[/SIZE]
[SIZE=1]End Sub[/SIZE]

 

[VoG]

It works for me.

 

[pedie]

My apologies...it works now.VoG, sorry I was careless again!!!

 

[pedie]

VBmodeless is working fine now but can i make the form be always in the top right corner automacticaly????

 

[VoG]

Try this in the userform's code module

Private Sub UserForm_Activate()
With Me
    .Left = Application.Width - .Width
    .Top = 0
End With
End Sub

 

[pedie]

VoG, that was a new learning...perfect...thanks alot!!!!