Can A Macro delete the macro button used to run it?
Posted by Chris Rock on July 06, 2001 9:33 AM
I have a template with a macro button on it. The workbooks created by that template have a macro button on them that runs a report, but the report can only be run once. If the button is accidentally pressed again, an error pops up.
Can I add code to the macro that will delete the button from the worksheet while the macro is running?
Thanks in advance.