Spellchecking a protected document in Excel

B

BeerHR

When I protect a sheet in Excel (the sheet has cells that can be filled in -
it's a form), I can't spellcheck the live cells. Help?
 
G

Gord Dibben

Note: not yet tested for Excel 2007

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

Excel --> Word 4
How to print an A4 document to 2 A5s 0
Dates In Excel 5
Problems created by Recent updates to Outlook 365 0
Merging from an Excel file with graphics 1
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Cell data entering slow! 0
Update several ppt documents from a single excel file 0

Top