Spell check with protected worksheet

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

Guest

Does anyone know how do setup that user can use spell check on the
unprotected range even with the protection is on?
 
Hi
not possible. You may create a macro (record one) which first
unprotects the worksheet, then runs the spell checker and protects the
sheet again
 
Such a macro could look like this.

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
 

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

Spell Check with protected worksheet 1
Excel Protection 2
Enabling Spell Check in Protected Worksheet 2
Spell Check Protect Reprotect with same settings 1
Spell Check Unlocked Cells Only 9
Spelling checker problem on a specific worksheet only 1
Protecting certain cells only & Spell check 3
Spell Checking in Protected Sheet 3

Back
Top