On Tue, 15 Jul 2008 16:08:33 -0600, salgud
wrote:

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!


Try this:

If ActiveWorkbook.Name = ThisWorkbook.Name Then

Hope this helps / Lars-Åke