Spell Check a Protected Excel Worksheet

0 Flares Filament.io 0 Flares ×

Worksheet protection is used in Excel to protect cells containing formulas, hide sensitive data and much more.

Unfortunately one of the problems that arises from protecting a worksheet is the inability to spell check a worksheet.

To be able to spell check a protected worksheet you need a macro to unprotect the sheet, perform the spell check, and then protect the sheet again.

Spell Check a Protected Worksheet

  1. Press Alt + F11 to open the Visual Basic Editor
  2. Click Insert > Module to insert a new code module
  3. Copy and paste the code below into the module window being sure to replace Stock Sheet with the necessary sheet name and excel with the necessary password.

Sub SpellCheckSheet()

Sheets(“Stock Sheet”).Unprotect “excel”

ActiveSheet.CheckSpelling

Sheets(“Stock Sheet”).Protect “excel”

End Sub

This code generates a macro called SpellCheckSheet. To run the code easily from the sheet, assign the macro to a button. This button can be placed on the toolbar and run at any time.

Related Links

Protect a worksheet in Excel

Create a Splash Screen in Excel

Use the Offset property in VBA

 

8 thoughts on “Spell Check a Protected Excel Worksheet

  1. Hi there Alan,
    I have tried this tutorial and when I change to name of the sheet to mine I get an error message which says “Compile error: Expected: list separator or )

    I copied and pasted the code so I’m not sure what I have done wrong – is there anyway you could help please?

    Thanks, Jo

  2. I have many tabs on my workbook “Sunday, Monday, Tuesday…
    I was able to run the spellcheck macro on “Sunday Sheet” under Module 1, HOW to set up the macro on other sheets? I followed the same method for other sheets and created a Module 2 for Monday but the spell check is given a error. Please help

Leave a Reply

Your email address will not be published. Required fields are marked *