Hi,
I have the below subroutine in ThisWorkbook.
It runs whenever the excel sheet is opened and that is the issue and it is running if the user double clicks on the sheet in the windows explorer even if the sheet doesn't open. Hence, Macro1 starts for the second time.
Please Login or Register to view this content.
How can I deal with this issue? I need only 1 instance of Macro1 to be running at any given time.
try thisPlease Login or Register to view this content.
it may not be the best way but im pretty sure it works
I dont like to use code i dont understand
it makes it hard to use in other situations
so please try to be as clear and patent as possible with me
Criticism is welcomed
You can't store a variable when closing a workbook. The information needs yp stored in a cell or maybe a Name
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks