View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

To do this manually try holding the ctrl key clicking on just the sheet
tabs you wantprint. when finishedclick any sheet tab

--
Don Guillett
SalesAid Software

"Barry Hull" <Barry
wrote in message
...
I would like to set up a workbook so that when I click print, Excel
automatically prints only certain worrksheets that I have chosen, rather

than
printing every worksheet. I am familiar with setting the print area, but
can't seem to stop Excel from printing every worksheet.

Regards,
Barry Hull