![]() |
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