View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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.