How to work on other excel files while running a macro?
Hi All,
I am very new to excel and also this forum. Actually I have designed a macro which consists of a form through it takes the input into excel sheet. The macro is running fine and I dont have any problems with it.
The problem I am facing is that after I start running this macro, I am not able to access any other open excel files.
Is there any option to make all other excel files available during running a macro?
Thank you all in advance..
Regards,
Manohar
Last edited by manohar.sv; 12-02-2008 at 07:43 AM.
Are you using a userform? If so you can set the ShowModal property to False
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
You can not run macro code AND use excel at the same time.
If you meant you have a userform displayed and want to access the worksheet then try showing the userform Modeless.
Hi AndyPope/royUK
Thank you very much for your reply.
I am able to work on other after I set the userform Modeless.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks