macro to spellcheck entire workbook
 

Does anyone have a macro for Excel 2000 that spellchecks
an entire workbook (ie - selects all worksheets, performs
spellcheck, then returns to only one worksheet selected)?
Is this possible? The excel workbooks I have all have
differently named worksheets.

Thanks for any help you might be able to provide.

macro to spellcheck entire workbook
 

Hi Excel-lent,

Try:

Sub Tester()
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Worksheets
WS.Cells.CheckSpelling
Next WS

End Sub

---
Regards,
Norman


"Excel-lent" wrote in message
...
Does anyone have a macro for Excel 2000 that spellchecks
an entire workbook (ie - selects all worksheets, performs
spellcheck, then returns to only one worksheet selected)?
Is this possible? The excel workbooks I have all have
differently named worksheets.

Thanks for any help you might be able to provide.

macro to spellcheck entire workbook
 

Excel-Lent,

This is a recored macro it should help


Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC",
IgnoreUppercase:=False _
, AlwaysSuggest:=True, SpellLang:=1033


Charles


---
Message posted from http://www.ExcelForum.com/