Spell Check in Protected Work Book

  • Thread starter Thread starter ChrisK
  • Start date Start date
C

ChrisK

Hi,
How can I leave spell check available for a range of cells while protecting
the rest of the sheet?
 
Hi Chris.

I have just conducted a simple test whereby I restricted access to 3 cells
but left the rest of the Worksheet available for edit.

In the above circumstances the Spell Checker is greyed out so it appears
that you are not able to do what you are looking for.

If my comments have helped please hit Yes.

Thanks.
 
Using a macro is the only work around that I know of.

Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Unprotects the sheet, does the spellcheck then reprotects the sheet.

"justme" can be changed to your password.


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

Similar Threads

using Spell check on protected sheet 6
using spell check on a protected sheet 2
Spell check 2
Protection Options Changes 2
Spell Check function on a protected sheet 1
Excel Move or Copy Stopped Working? 0
How can I use spell checking in a protected worksheet? 1
Unable to Spell Check in Excel 2

Back
Top