Spell Check Protected Excel Sheet

In the review tab there is an option spelling as shown in the image.

Spell check protected excel sheet. You can tell it to spell check multiple sheets at once with a simple trick. Subscribe for weekly excel tips and tricks helpful tutorials delivered to your email. In the microsoft visual basic for applications window click insert module.

Spell check for protected excel sheet i want spell check for a certain range in a protected worksheet. Spell check a protected worksheet. Please run the below vba code to enable the spell check feature in a protected worksheet.

Then run spell check as normal. Select the cell you need to enable the spell check in the protected worksheet then run the vba code by pressing the f5 key. Before pressing f7 or the spelling button right click on any sheet tab and click select all sheets.

Clicking this option will initiate the spell checking. 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. Press the alt f11 keys simultaneously to open the microsoft visual basic for applications window.

By default excel only looks at a single sheet when checking spelling. 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. Enable spell check in protected worksheet excel.

Is there a way to turn it on while keeping protection on. If you want to use it you must unprotect the worksheet run the check and then protect it again. Then copy and paste the below vba code into the module window.