Macro to delete a worksheet before Save As

[Keith24249]

Hi,
I would like to write a piece of code that would run when I click "Save As". I need it to delete a worksheet called "DATA" when I click Save As. I have searched many forums and googled it but nothing seems to work. The workbook is compiled in Excel 2007. Can anyone help. If you would like a copy of the workbook please let me know.
Regards
Keith

 

[AlphaFrog]

The one line (On Error Resume Next) only ignores errors. It doesn't prevent the code from executing. So if the code in the template worked before, it will still work.

Does the template still have a sheet named Data and is there a value in E2?

When you close the template, do you save it so the new value in E2 is saved and it will be incremented the next time?

 

[Keith24249]

When I do a "save as" I save the workbook (minus DATA worksheet) in a customer folder using the unique number generated by the code so that it can be re-opened ad infinitum.
At this stage the template isn't closed by me it closes itself, when I reopen it has a worksheet called DATA but the number does not increment by 1
Regards
Keith

 

[AlphaFrog]

Well apparently you need to save the template so the value in "Data" E2 is saved and it will be increased when you open it the next time.

Whatever code you have that closes the template needs to include as save command.