Error Msg 400 - Macro Spell Check
Can you post your code?
Assuming ".doc" means an Excel.xls workbook since you're posting an an Excel
group..................
You cannot Spellcheck on a protected sheet.
You must unprotect, spellcheck then reprotect.
Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub
Gord Dibben MS Excel MVP
On Wed, 13 Dec 2006 09:31:09 -0800, Rog wrote:
We keep getting an error msg 400 for a spell check macro in protected doc.
What is this error message and what do we do to correct it?
Thanks,
Rog
|