View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?