R
ray1.wilson
How can I get what the user response is when attempting to delete a
worksheet using a macro - ActiveWindow.SelectedSheets.Delete
When I try to delete a worksheet, a prompt box "Data may exist in the
sheet(s) selected for deletion. To permanently delete the date, press
Delete.
The user can then select Delete or Cancel, basically I want the macro
to know what the user has selected
worksheet using a macro - ActiveWindow.SelectedSheets.Delete
When I try to delete a worksheet, a prompt box "Data may exist in the
sheet(s) selected for deletion. To permanently delete the date, press
Delete.
The user can then select Delete or Cancel, basically I want the macro
to know what the user has selected