View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Spell Check cells in Protected Worksheet?

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 Thu, 27 Jul 2006 11:17:02 -0700, Jugglertwo
wrote:

Is it possible to run the spelling checker on a worksheet when the worksheet
is protected?
It doesn't appear that it is possible through Excel's "normal" options.
A customer has created a protected Excel form with certain cells unlocked
for data. If the person misspells data in these cells, the spelling checker
is not available.
Any way around this?
Any suggestions would be appreciated!
Thanks.
Jugglertwo


Gord Dibben MS Excel MVP