View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default 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