View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ypukpete ypukpete is offline
external usenet poster
 
Posts: 26
Default Print page one of sheet only

I am using the code, Application.Dialogs(xlDialogPrint).Show (so the user can
select their printer) and I need to disable the Print Range in the dialog box
so that other pages cant be printed.
Is there code I can use to only print page 1 of the sheet. I have tried code
that works but if you click cancel in the dialog box it goes ahead and prints
it anyway. I hope this makes sense to one of the experts. Thanks for any help
--
ypukpete