I have a macro that moves a Calculations worksheet into a file for calculating rates. Once the rates are calculated and moved to the Quote Sheet, I would like to delete the Calculations worksheet from the file. When I record the macro, Excel requires the user to confirm deleting the worksheet by pressing the "delete" or "cancel" button in the Excel Popup window. How can I set up the macro so that the macro automatically deletes the worksheet without the user having to press the "delete" button?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Deleting a worksheet during a macro
- Thread starter bam
- Start date
Similar threads
- Question
