Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activeworkbook and thisworkbook
At the beginning of a macro I'm writing, I'm trying to test to make sure
that the activeworkbook is not the one the macro is in. I put this line in: If ActiveWorkbook = ThisWorkbook Then followed by a message box to the user. But I'm getting an "Object doesn't support this property or method" error on this line. How do I text this correctly? Thanks again! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ThisWorkbook/ActiveWorkbook | Excel Programming | |||
Help with ThisWorkbook | Excel Programming | |||
Help with ThisWorkbook | Excel Programming | |||
ThisWorkbook vs. ActiveWorkbook? | Excel Programming |