I need VBA to delete some worksheets as part of a macro but it asks me if I'm sure I want to delete (because data will be permanently lost). How can I "force" my answer to be yes, delete the sheets?
Dialog text is: "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press delete."
Dialog box choices are: "Delete" and "Cancel"
Hi Chad, welcome to the forum.
You can certainly do this, but remember - it's not always safe to automatically delete things. The example below should provide you with the information you need:
Sheet2 will be gone faster than you can say "$#!*% Microsoft!!"
Please Login or Register to view this content.
Thanks - worked like a charm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks