VBA Forums

[jai2808]

Hi,
I have written an excel macro, which uses a VBA form, where users are using this macro, they are unable to open other excel files.Is there any method to overcome this hurdle.
Thanks,
Jai

[royUK]

Why do you need to switch workbooks if the Form is open?

[jai2808]

We need to open other workbooks to update the data from the macro as this macro is getting connected to extra object,I read some data from the mainframe using extra object, users need to update the data into an another workbook.
Could some one please help.
thanks,
jai

[royUK]

I still don't follow, if you are running a macro then you can't manually open other workbooks anyway.

If you want the form visible whilst manually working with excel then you need to make your form modeless, In the Prperties Window of the UserForm scroll down until you find ShowModal, by default this is set to True, change it to False.