Run Auto_open only if file it's in is not a particular name.

[mikeburg]

Trying to figure out VBA that runs Auto_open only if the file it's in is not a particular name.

In other words, I am trying to prevent an Auto_Open call procedure from executing when the sheet is opened under another name it has previously been Saved As. For example, Study.xls has been saved as StudyPurged.xls. So when I open StudyPurged.xls the call procedure does not execute as follows:

Please Login or Register  to view this content.

I just can't figure out the If statement. Any help would be greatly appreciated. mikeburg

[mikerickson]

Please Login or Register  to view this content.

Please wrap your code.

[mikeburg]

Works great. Thanks a million for the help.

Sorry about the wrap. I am not very good at this. I promise to do it from now on.

This web site is my only salvation sometimes!

Thank you. mikeburg