Error Msg 400 - Macro Spell Check
 

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

Error Msg 400 - Macro Spell Check
 

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

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