Hi,
So I have 3 macros in a workbook, each of which has the condition set as If ActiveSheet.CodeName = "XXX" Then ...
The problem is that for one of them the macro still runs in every worksheet. I have tried both activesheet.name and codename with no luck.
If I change between the 2, it will work only once and the the macro will run in every worksheet afterwards.
Below is the macro:
Any help will be appreciated.
Please Login or Register to view this content.
Try adding a selection of the sheet right after the If statement.
Is the case correct on the sheet's name?
P.S. the first part of your sub didn't make it to the post.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
thanks for the fast reply:
full script below, the name is all in small letters, no caps.
what do you mean by "Try adding a selection of the sheet right after the If statement. "?Please Login or Register to view this content.
doe you mean to do:
I used to have that and removed it. but it still seems to run no matter whatPlease Login or Register to view this content.
Last edited by alexaa; 05-31-2013 at 12:14 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks