Spell check when worksheet is protected

[Brian]

I made a spread sheet for work the has some cells protected then a password.
But once I enable the password, the spell check cannot be used.

Any help would be appreciated

 

[Gord Dibben]

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

 

[Whitney]

This process is new to me. How would I implement this in Excel?

 

[Gord Dibben]

With your workbook open, hit Alt + F11 to open the Visual Basic Editor.

Ctrl + r to open the Project Explorer.

Right-click on your workbook/project and Insert>Module.

Paste the macro into that module.

Alt + q to return to the Excel window.

Protect the sheet with the password "justme"(no quotes)

Then run the macro from Tools>Macro>Macros or assign it to a button or shortcut
key.


Gord