Delete Spreadsheet without Error
Mike
you could try:
Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True
Regards
Trevor
"Mike D." wrote in message
...
Hi.
I currently am deleting sheets in a macro with the command:
ActiveWindow.SelectedSheets.Delete
Each time it is executed, it prompts me with a message
that says "Data may exist ..."
How do I tell my macro to skip this?
Thanks,
Mike.
|