spelling check on a protected spreadsheet
Thank you All, I've done it. I've used the Paul B approach:
Sub Spell_Check()
ActiveSheet.Unprotect Password:="123"
Cells.CheckSpelling _
CustomDictionary:="CUSTOM.DIC", _
IgnoreUppercase:=False, _
AlwaysSuggest:=True
ActiveSheet.Protect Password:="123"
End Sub
"Alex" wrote:
Hi,
Can I allow a user to do a spelling check on a protected spreadsheet if some
cells/columns are awailable for the data entries?
Thanks
|