View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] boonarga@gmail.com is offline
external usenet poster
 
Posts: 5
Default Print only 1 sheet in a workbook.

I have a workbook with sheets numbered 1 to 20. On another sheet I
have a print button. I need to have the print button work so that it
prints just 1 of those 20 sheets. The sheet number to be printed will
be in a cell on sheet Data3, Cell:C7.

The print button is on another sheet.

I'm at a loss to write a macro that can do this job.
Can anyone help?

Thanks