ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatically Spell Check Before Printing (https://www.excelbanter.com/excel-programming/436874-re-automatically-spell-check-before-printing.html)

Gord Dibben

Automatically Spell Check Before Printing
 
Place this event code in Thisworkbook Module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.Cells.CheckSpelling SpellLang:=1033
End With
End Sub


Gord Dibben MS Excel MVP

On Tue, 1 Dec 2009 08:25:01 -0800, Stacey Crowhurst
wrote:

Hi. How do I set up my worksheet to automatically run spell check when I
click the print button? Let me know if you need more information.

Thank you in advance !!! :)

Stacey




All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com