ExcelBanter - signed project drops signature when a macro creates a new sheet.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - signed project drops signature when a macro creates a new sheet. (https://www.excelbanter.com/excel-programming/381047-signed-project-drops-signature-when-macro-creates-new-sheet.html)

whylite

signed project drops signature when a macro creates a new sheet.

I have a balance sheet that when is full creates a new sheet with the same
macros as the original. The macro creates the change yet the signature is
lost because the VBA project changes when the new sheet is created. Can a
macro be writen that would resign the workbook everytime this action is done.

--
Thanks!
Shane W

All times are GMT +1. The time now is 09:01 AM.