How can I set cancel = ture in this event?
I want to prevent user from deleting sheet without protecting the sheet
This code shows errors
Please Login or Register to view this content.
How can I set cancel = ture in this event?
I want to prevent user from deleting sheet without protecting the sheet
This code shows errors
Please Login or Register to view this content.
There is no Cancel argument for that event. You can't just add one.
Rory
Not sure I understand why you'd need to protect the sheet in order to allow it to be deleted.I want to prevent user from deleting sheet without protecting the sheet
However, in some cases you can work around the lack of Cancel by copying the sheet prior to the delete going ahead.
Please Login or Register to view this content.
I didn't read it that way: I believe the OP wants to stop anyone from deleting the sheet without having to use sheet protection himself.Not sure I understand why you'd need to protect the sheet in order to allow it to be deleted.
EDIT: Thread has been marked as solved, though.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Oh yes, that makes more sense.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks