I'm writting a macro, which partially involves deleting worksheets. Currently I'm just using
Worksheets(WS).Delete
where WS is dim as a worksheet
But when this command is run, the message "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete." which freezes the macro and waits for the users response. Is there a way to make this message not pop up either in excel options? or preferably an override in the VB code?
Thanks so much![/code]
Worksheets(WS).Delete
where WS is dim as a worksheet
But when this command is run, the message "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete." which freezes the macro and waits for the users response. Is there a way to make this message not pop up either in excel options? or preferably an override in the VB code?
Thanks so much![/code]