Spell Check w/ Protection

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

Guest

Does anyone know how you can enable spell checking for a protected worksheet?
 
Hi
you can't. You may record a macro which first unprotects the sheet, executes
spell checking and protects the sheet again
 
Thank You. Excellent suggestion that I think will do the job. Have a Happy
New Year.
 
Requires VBA to unprotect the sheet, do the spellcheck then reprotect the
sheet.

Similar to.......

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
 
You must log in or register to reply here.

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

Enabling Spell Check in Protected Worksheet 2
spell check on protected sheet 2
Spell Check on Excel document 2
Spelling checker problem on a specific worksheet only 1
Spell Check in Protected Worksheets 3
How does a user spell check protected document in Excel? 6
Spell Check 5
Check Spelling With Sheet Protected 1

Back
Top