View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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