Here's about as easy a code as I could come up with. It will check both
pages but will only show the page that is active when it is run.
Sub spell_check()
Worksheets("Sheet1").Cells.CheckSpelling SpellLang:=1033
Worksheets("Sheet2").Cells.CheckSpelling SpellLang:=1033
End Sub
' This second example switches to the page the spell check is being run
on.
Sub spell_check2()
Worksheets("Sheet1").Select
Cells.CheckSpelling SpellLang:=1033
Worksheets("Sheet2").Select
Cells.CheckSpelling SpellLang:=1033
End Sub
--
goober
------------------------------------------------------------------------
goober's Profile:
http://www.excelforum.com/member.php...o&userid=19838
View this thread:
http://www.excelforum.com/showthread...hreadid=480132