Can I set up a worksheet to automatically only print the active cells each time it is printed?
E eab Apr 5, 2005 #1 Can I set up a worksheet to automatically only print the active cells each time it is printed?
R Ron de Bruin Apr 5, 2005 #2 Hi eab You can use this event in the Thisworkbook module Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True Application.EnableEvents = False Selection.Areas(1).PrintOut Application.EnableEvents = True End Sub
Hi eab You can use this event in the Thisworkbook module Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True Application.EnableEvents = False Selection.Areas(1).PrintOut Application.EnableEvents = True End Sub
