Hi there
I try to have a macro delete Shhet1 in a workbook (being the active sheet) and add a new one, name it "sheet1" and select cell"A1".
It works fine, but it always gives me the message "The sheet will be deleted permanently" with the choice of accepting or not.
Now since this macro is embedded in a long code, it interrupts the running of the operation and requires user input.
How to avoid??
Hans
I try to have a macro delete Shhet1 in a workbook (being the active sheet) and add a new one, name it "sheet1" and select cell"A1".
It works fine, but it always gives me the message "The sheet will be deleted permanently" with the choice of accepting or not.
Now since this macro is embedded in a long code, it interrupts the running of the operation and requires user input.
How to avoid??
Hans