View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
 
Posts: 189
Default Spell Check with protected sheets

Hi,

Try this
Sub Spell_Check()
ActiveSheet.Unprotect Password:="Tech09"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="Tech09", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Unprotects the sheet, does the spellcheck then reprotects the sheet.


"Tech09" can be changed to your password.





--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Karissa" wrote:

I read the past posts on doing sprell check on a protected sheet but still
having issues.

I need a macro that will do spell check on only unlocked cells (this
includes text boexes) Any help?

Thank you
--
Karissa