Hello,
I have following code that will delete the sheet named kirok when the user selects the values in the drop down list from "yes" to "no". But the problem is its not protecting the workbook back post deletion. can you please suggest?
Please Login or Register to view this content.
I'm guessing it's hitting the Exit Sub in your loop and dropping out. Probably need Exit For there instead.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi,
The second Protect call is actually unprotecting the workbook again. There does not seem to be any need to unprotect unless you delete the sheet, so I would suggest amending your code accordingly:
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Glad i found this. I had a similar requirement and this worked a treat.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks