Locked sheet with unlocked cells Spell Check Macro

Hello-

I have been working on a performance review form that calculates the rating for the user. I have locked the worksheet to prevent changes to my formulas. The user is unable to do a spell check. I have done some research and tried to create the macro needed to spell check selected cells but it is not working. Is there anyone who can help me with solving this? I should note that I have absolutely no experience with macros TEMPLATE ANNUAL REVIEW.xlsx

Jodi

Hi,

I am new to VBA myself hence the below may not be the best solution but it dose work:

Right click on the Sheet Tab and click on view code and paste the below

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+q
'
Sheets("Sheet1").Unprotect Password:="abcd"
Cells.CheckSpelling SpellLang:=1033
Sheets("Sheet1").Protect Password:="abcd"

End Sub

before that please protect your sheet with password "abcd" or whatever else you like (just make sure password as in code and the one you enter are same)

As you can see the code i had given above is run with a keyboard command hence you have to additionally after all the above is done have to click on view macro in the xls sheet and then on option and then have to enter "q" in the shortcut key option.

I would be glad if you found and share better option.

Thanks,
CVishu

Thank you for your help. I was able to find the script needed and I actually got it to work, however, when I try to save my document a message tells me I can't save the macro in that workbook and need to save it as a macro enabled document. I have tried saving this way but then when I try to run the macro in the macro enabled document, I get a message telling me that the macro doesn't exist in the workbook or all macros have been disabled. Can you tell me what I am doing wrong when saving?