Object required error in macro

[Sumit]

Any idea on how to check if the project being saved is global.mpt and not to run the following macro?

As this works fine for projcts but not when I close the App.

 

[John]

Sumit,
How about simply inserting an 'IF' statement that looks at the file path
before line 2 and checks for ".mpt". If the extension is hidden, just
check the file name.

John

 

[Sumit]

I did set the code to check "if not pj is nothing then"

this won't go ahead if its global.mpt

Regards,
sumit