Deleting a Sheet

A

Abdul Salam

If you Protect the workbook sheet delete will be disabled

Tools>Protection>Protect Workbook

Abdul Salam
 
R

Rick De Marco

Thanks Abdul, but I need to allow the user to delete the sheet if it
does not contain certain information (which I can catch in my code).
Basically I need to catch the deleting in an event and then determine if
they are allowed to delete it or not. If not, then I need to display a
message and stop them from deleting. Displaying the message if fine, but
how to I stop the actual deletion of the sheet once they have selected
delete on the Excel message box? Can this be done?

Thanks, Rick

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password protect new workbooks from template 0
selecting workbook/sheet 3
Shared Workbooks & Code 1
quick way to prohibit all editing/changes to workbook (2010) 2
To disable Right Click Q 1
Sharing workbook removes cell protection 1
Sheet protection complications 0
Unprotect sheet when Saving As 2

Top