I have created a template spreadsheet and locked & protected some calc cells.
But the user now need to spell check the spreadsheet, but it is not
available while the spreadsheet is protected.

Is there any way this can be resolved, withouth unprotecting the sheet.

Thanks
Emma

dump it into word and run a spell check there then manually change the
spreadsheet

"Emma" wrote:

I have created a template spreadsheet and locked & protected some calc cells.
But the user now need to spell check the spreadsheet, but it is not
available while the spreadsheet is protected.

Is there any way this can be resolved, withouth unprotecting the sheet.

Thanks
Emma

Emma

You can use this macro to unprotect, run the spellcheck, then re-protect the
sheet.

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

On Tue, 19 Jul 2005 02:36:02 -0700, "Emma"
wrote:

I have created a template spreadsheet and locked & protected some calc cells.
But the user now need to spell check the spreadsheet, but it is not
available while the spreadsheet is protected.

Is there any way this can be resolved, withouth unprotecting the sheet.

Thanks
Emma