How can I use spellcheck on a spreadsheet that is protected?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that we use in my companies field laptops. We protect
the worksheet so that they can't change the format but when we do that the
spell check option diapears. Is there a way to give them permissions to use
this feature while keeping the form protected?
 
abarr wrote...
I have a spreadsheet that we use in my companies field laptops. We protect
the worksheet so that they can't change the format but when we do that the
spell check option diapears. Is there a way to give them permissions to use
this feature while keeping the form protected?
Click to expand...

The simple answer is NO.

The complicated answer is that you could use macros to create new,
unprotected worksheets, copy unprotected cells' contents one by one to
the new worksheet, spell check there, copy the corrected text back to
the protected worksheet, and finally delete the new worksheet.
 
Requires VBA to unprotect the sheet, do the spellcheck then reprotect the
sheet.

Similar to.......

Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub


Gord Dibben Excel MVP
 
Back
Top