Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
running macro in entire workbook | Excel Discussion (Misc queries) | |||
Name an Entire Workbook | Excel Discussion (Misc queries) | |||
Spellcheck Macro Help | Excel Discussion (Misc queries) | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming |