Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
Good afternoon
Does Excel 2000 have an On Print event. I have a worksheet that i want to hide a couple of columns before printing the unhide them after, can anyone help? Thanks in anticipation |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing
John,
Private Sub Workbook_BeforePrint(Cancel As Boolean) End Sub It's in module ThisWorkbook. In the VBE, open the code window for the ThisWorkbook module (double-click it in the Project Explorer). Once in that module, set the object (left) box to Workbook. Now the Procedure box (right) will contain workbook events. Open it and select BeforePrint. It'll put the event sub above in the module. Put your code in there. -- Earl Kiosterud www.smokeylake.com "John" wrote in message ... Good afternoon Does Excel 2000 have an On Print event. I have a worksheet that i want to hide a couple of columns before printing the unhide them after, can anyone help? Thanks in anticipation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) | |||
Printing? Worksheets not printing the same on multiple pc's! | Excel Programming |