spell check on protected sheet
Hi,
Try this in a general module.
Sub SpellCheck()
ActiveSheet.Unprotect Password:="MyPass"
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", AlwaysSuggest:=True
ActiveSheet.Protect Password:="MyPass"
End Sub
Mike
"spell check on protected sheet" wrote:
I have a worksheet where the questions are protected but the responses areas
are not. Is there anyway to enable the spell check on a protected sheet?
|