Run a SaveAs VBA formula then disable the SaveAs formula in Workbook

Hi Excel Forum Experts,

I have found a VBA code that works but i need it altered so that when it runs, the code in the new Macro Workbook is disabled so when the new workbook is reopen next time the code does not run. So If you have filled out data in the new macro workbook i just want it to open on next open as it would get very messy if you have to keep clicking save as and override the the file you are working on and you might end up overriding the wrong file.

How do i alter this code to make sure it is disabled on new file after save.

The VBA Code i am using is the followingwhich is stored in the ThisWorkbook section

Please Login or Register  to view this content.

TIA for any assistance

Thanks
Donald

You can make the code work dependent on the name of the workbook. If the name is different from the defined one, the inside of the condition will not execute:

Please Login or Register  to view this content.

Artik

Thanks for your assistance Artik this has worked how i wanted it to.

Thanks
Donald

This post is also cross-posted over at MrExcel at the following link sorry for not making it as a cross-post.

https://www.mrexcel.com/board/thread.../#post-6193269

Donald