I think we're talking about two different issues (or I'm being very stupid!)
I already allow users to type into the protected worksheets by having the designated cells as 'unlocked'. I just tried the 'allow users to edit range' option out of interest and couldn't get it to work anyway?
The issue is that I want to prevent the users from being able to delete one worksheet but not be prevented from deleting the others - protecting the sheet does not affect this and protecting the workbook disables the delete option for all the worksheets. I'm wondering if it has to be some VB code to activate/deactivate the protection dynamically or some such.
Bookmarks