Microsoft Office Forums - View Single Post - Is it possible to use a vba macro to delete other macros?

Guessed · 09-05-2023, 08:23 PM

There will be a Catch 22 with implementing that idea: Not possible to delete the file while it is open AND the file needs to be open while the macro is running.

The usual method to do this would be to create the macro and store it in a different workbook (or your Personal.xlsb) so the code never resides in the template workbook.