Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm missing something simple. I have the following code in ThisWorkbook:
Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.PrintArea = ActiveCell.CurrentRegion.Address End Sub But it's not happening, just prints the selected cell instead of the Current Region. An Edit Goto Current Region selects the correct Current Region. I copied the code from an online tutorial, and read a reviewed the VBA Help, and can't figure out what's wrong. I'm in Win2000, XL2003. Anybody see what I'm missing? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
BeforePrint | Excel Programming | |||
BeforePrint | Excel Programming | |||
BeforePrint | Excel Programming | |||
ADO 2.7 & ADO 2.8 beforeprint | Excel Programming | |||
Help with BeforePrint | Excel Programming |