Rich,

Thank you very much for taking the time to do the research and following up
with me. I am aware of the code "CheckSpelling" and the code from below, and
I am trying to avoid using the code from below, if possible.

I guess that is the only option available, and it's kind of make sense that
how can you check for spelling and fix the spelling if the worksheet is
protected.

Thanks again. Have a great weekend!


"Rich Locus" wrote:

Hello:

I researched your request, and reviewed some of the MVP responses from past
years on this issue. The spreadsheet MUST be unlocked to do a spell check,
but here was a suggestion from one MVP... create a "Spell Check" button and
use this macro (again, this came from another MVP):

Sub SpellCheckIt()
Sheets("Sheet1").Unprotect "password"
ActiveSheet.CheckSpelling
Sheets("Sheet1").Protect "password"
End Sub

--
Rich Locus
Logicwurks, LLC


"Accesshelp" wrote:

Hello all,

I have an Excel file that password-protects the worksheets and workbook.
Due to the password-protecting the worksheets, the Spelling option under
Tools menu is not available.

Could someone help me with a code to have the Spelling option enabled while
the worksheets are password-protected?

Thanks.