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

[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?

 

[Harlan Grove]

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?

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.

 

[Gord Dibben]

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