Auto open only once?

I have a macro that needs to automatically run the first time my workbook is opened (the first time after the macro is created and the file is saved/closed, obviously), then never run again (not automatically, any way). Is there any way to accomplish this?

Perhaps put a number in a sheet somewhere when run and add a check on whether number is present? e.g. if A1=1 then already run so don't run again.

Steven, I thought of that, but how do I tell it to not run again? Right now it's auto running because I named the macro auto_open.

Originally Posted by StephenR

Perhaps put a number in a sheet somewhere when run and add a check on whether number is present? e.g. if A1=1 then already run so don't run again.

Instead of auto_open, why not put the code in the Workbook_Open event (in the ThisWorkbook module) and then you can add a line at the beginning, if a1=1 then exit the sub.