View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronny Hamida Ronny Hamida is offline
external usenet poster
 
Posts: 16
Default BeforePrint Event - "PrintOut" does not give Print Dialog

Hello again!

I have a BeforePrint event to unhide, print, then hide rows again. The
problem is that I would still like to allow the use to see the print dialog
to choose their own particular settings (such as which tray, double-sided
printing, copies, etc.) Is this possible? Is there something else beside
the PrintOut command that I should have instead? Here's what I have now:
..
..
..
With ActiveSheet
.Rows("33:41").EntireRow.Hidden = False
.PrintOut
.Rows("33:41").EntireRow.Hidden = True
End With
..
..
..
It works just fine, but I would like the user to get the normal Print dialog
window.

Thanks in advance!

Ronny