spell checking options

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

Guest

With a worksheet protected, is there a way to spell check entries in cells
that are not protected?
 
dvs, Not without VBA, you could use some code to unprotect the sheet run
spell check and then protect the sheet like this

Sub Spell_Check()

Const Password = "123" '**Change password here**

ActiveSheet.Unprotect Password:=Password

Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _

, AlwaysSuggest:=True

ActiveSheet.Protect Password:=Password

End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
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




With a worksheet protected, is there a way to spell check entries in cells
that are not protected?

Gord Dibben MS Excel MVP
 

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

Back
Top