vbModeless doesn't work

[hunna]

Hello, I call Userform through click button on data sheet. My problem is I want to work on worksheet while Userform is still active. I tried to use the code but it doesn't work.

Private Sub Workbook_Open()
    XcelL.Show vbModeless 'Or vbModal
End Sub

PS. I add this code in modul1.

Anybody can help?

Thanks,

 

[RoryA]

In what way does it not work?

 

[hunna]

Hi rorya,

In what way does it not work?

I open the workbook then call the Userform but still can't move my data sheet.

 

[RoryA]

That code should be in the ThisWorkbook module if you want it to run when you open the workbook (if not, don't call it Workbook_Open) but it should work fine.