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

Look for "Trappable Errors" in Word VBA help.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Rog"
wrote in message
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

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