Can't set userform to modeless!

[fcb1900]

Hi, i'm calling a userform that is being populated with data from another workbook. The code opens the sourcebook and keeps it in read-only modus until i close the userform which is fine. However it seems that this prevents me from setting my userform to vbmodeless! I tried false true app.enableevents but to no avail.. Below is the Initialize event of the form. Does anybody have any idea to fix this? Thank you very much!

Please Login or Register  to view this content.

[jaslake]

Hi fcb1900

You didn't post the code that opens the Userform but I'd assume it looks (or shoud look like) this

Please Login or Register  to view this content.

Hope this helps.
John

[fcb1900]

Hi John, thanks for your answer, yes of course it does look like this

[jaslake]

Hi fcb1900

Sorry then, have no clue.

John

[royUK]

It might help if you put ScreenUpdating back to True