Run Spell Check

I currently have a protected worksheet that allows the user to type text into a series of unprotected cells. In order to run spell check the user has to unprotect the worksheet, run spell check and re-protect the worksheet.

Is there a way to run spell check on the unprotected cells, or unprotect the worksheet, run the spell check and re-protect the worksheet? I could then simply assign it to a button on the worksheet.

Any ideas?

Thanks.

Worked Great! I added the password option to the code, but when I add it to the ActiveSheet.Protect at the end I get an error unless I remove the

"DrawingObjects:=True, Contents:=True, Scenarios:=True"

Please Login or Register  to view this content.