How To Spell Check Protected Sheet In Excel

Then the spelling dialog box pops up in the protected worksheet as below screenshot shown. This macro is basically doing the same as unprotecting the sheet, clicking tools, spelling, running through the normal spell check procedure and then.

How To Spell Check In Excel

If you select a single cell for spell check, excel checks the entire worksheet, including the comments, page headers, footers and graphics.

How to spell check protected sheet in excel. Sub spellchk () sheets (sheet1).unprotect password:=your_password range (a1, a3, a5).checkspelling sheets (sheet1).protect password:=your_password end sub. How to spell check protected sheet in excel. Add the addresses of your unprotected cells to the range entry list, change your sheet name, and the password of course.

Sub spellcheckit() sheets(sheet1).unprotect password activesheet.checkspelling sheets(sheet1).protect password end sub you'll need to change sheet1 to whatever your sheet name is. How to spell check protected sheet in excel. In order to have the macro complete these steps, you must know the password used to protect the worksheet.

This macro is basically doing the same as unprotecting the sheet, clicking tools, spelling, running through the normal spell check procedure and then. Excel allows to immediately perform spell check within the entire sheet by pressing the function key 'f7' on the keyboard. If you select a single cell for spell check, excel checks the entire worksheet, including the comments, page headers, footers and graphics.

Select the cell you need to enable the spell check in the protected worksheet, then run the vba code by pressing the f5 key. The following simple example assumes that the password is mypass. sub spellcheckcell1 () with activesheet.unprotect (mypass).range (a15).checkspelling.protect (mypass) end with end sub.

Spell Check A Protected Excel Worksheet