Excel: protect workbook disables spell check?

pjeanetta
pjeanetta used Ask the Experts™
on
I have run into a snag and I do not know if it is solvable or not.  I have an Excel Spreadsheet where some of the cells are locked and others are not.
As you know, to enable the locked cell, the worksheet must be protected.
However, I discovered that the minute you protect the sheet, spell check on the unlocked cells in not available.  Has anyone had a problem with this and
did you find a solution (other than unprotecting the sheet) to enable a partial spell check.  Auto correct does not seem to work once it is protected either.  Any help would be appreciated.
Thanks, Jeanetta
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2006
Commented:
Hello Jeanetta,

This question came up earlier this week, in vb i guess haven't seen anything there

you could try this procedure, which protects the user interface only, and opens the Spelling dialog box:

Sub mySpellCheck()
   With ActiveSheet
     .Unprotect Password:="password"
     .Protect Password:="password", _
       DrawingObjects:=True, _
       Contents:=True, _
       Scenarios:=True, _
       UserInterfaceOnly:=True
     .Cells.CheckSpelling
   End With
End Sub

HAGD:O)Bruintje

Author

Commented:
Bruintje,

this will work - thanks!
(It seems to be so easy, how had I not came to it? :)) )

Gruss,
Jeanetta

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial