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
|