Protection Options Changes

[Guest]

I have a spreadsheet that allows users to enter text into unlocked cells. I
have protection set to allow users to "Select unlocked cells". This is the
only protection option selected. However, for some reason the "Select locked
cells" option is becoming checked. For obvious reasons I don't want data
entered into locked cells. The spreadsheet does use a macro for spell
checking the sheet. I suspect the issue has somthing to do with the spell
check macro, but haven't been able to duplicate it.

 

[Guest]

Harold,

You can't spell check a locked sheet in the usual way (Tools|Spelling) so
your spell check macro is (maybe) un-protecting the sheet doing the spell
check and re-protecting but getting that re-protection wrong.

Just a point, the fact that a user can select a locked cell doesn't mean
they can update it. Why not post the spell check macro?

Mike

 

[Guest]

Mike
I run the spell check macro and protection remains as set. However the next
day after several users have entered data the protection changes to allow
users to "Select locked cells. I posted the macro below,"*****" represents
the password

'
ActiveSheet.Unprotect "******"
Application.Goto Reference:="Print_Area"
Selection.CheckSpelling SpellLang:=1033
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True _
, AllowInsertingRows:=False, AllowDeletingRows:=False
ActiveSheet.Protect Password:="******"
End Sub