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.
|