Spell Check In Protected Excel Sheet

Spell check for protected excel sheet i want spell check for a certain range in a protected worksheet.

Spell check in protected excel sheet. So the process of doing the desired spell checking is to unprotect the worksheet do the check and then again protect the worksheet. How to allow external data refresh in protected worksheet in excel. The problem of course is that the spell checker cannot be run on a protected worksheet.

Then the spelling dialog box pops up in the protected worksheet as below screenshot shown. How to allow edit objects in protected worksheet in excel. Craig has a protected excel worksheet in which he would like to spell check a specific cell.

Spell check a protected worksheet press alt f11 to open the visual basic editor click insert module to insert a new code module 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.