Hello all,
This should be simple - I've done this before, but clean forgotten how!
I have a macro that deletes a worksheet, but I want the macro to delete it without asking the user to confirm. How do I supress the message?
Thanks.
Hello all,
This should be simple - I've done this before, but clean forgotten how!
I have a macro that deletes a worksheet, but I want the macro to delete it without asking the user to confirm. How do I supress the message?
Thanks.
You can use this and it will take the default action...
![]()
Application.DisplayAlerts = False
It's OK, I've remembered.
![]()
Application.DisplayAlerts = False
Thanks Stuie, I remembered just before you posted. My old grey matter is a bit slower these days...!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks