Spell Check w/ Protection

  • Thread starter Thread starter Guest
  • Start date Start date
Hi
you can't. You may record a macro which first unprotects the sheet, executes
spell checking and protects the sheet again
 
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
 

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