#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 160
Default Thanks

Thanks for your reply. I'll try this out...
-----Original Message-----
Hi,

add following code into your sub.

For Each Sht In ThisWorkbook.Sheets
Sht.Cells.CheckSpelling
Next


--
Regards

Haldun Alay

To e-mail me, please remove AT and DOT from my e-mail

address.



"Phil Hageman" ,

iletide sunu yazdi news:028601c3a557$ee9d7460
...
Can someone suggest how to add a spell check for all
worksheets in the following code (and any other
suggestions too)...

Sub SaveAndClose()
Range("A10").Select
Range("A9").Select
Range("A8").Select
Range("A7").Select
Range("A6").Select
Range("A5").Select
Range("A4").Select
Range("A3").Select
Range("A2").Select
Range("A1").Select
ActiveWorkbook.Save
ActiveWindow.Close
'Application.DisplayFullScreen = True
End Sub

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"