Protection Options Changes


G

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.
 
Ad

Advertisements

G

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
 
Ad

Advertisements

G

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
 

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

Top