View Single Post
 
Old 11-16-2015, 04:13 AM
terrymac terrymac is offline Windows XP Office 2007
Novice
 
Join Date: Nov 2014
Posts: 8
terrymac is on a distinguished road
Default How can set a command to print only specific sheets?

Before I start some information on the spreadsheet I am asking for help on; it is used for Export Documentations, and there are a lot of different sheets needed.

So I have set up about 20 sheets in my work book, of which the first two are "data entry" sheets, and the rest are hidden. Once the user has filled in the only two viewable sheets this unhides some of the relevant sheets.

From this there are always
>> INVOICE (sheets named INVOICE01, INVOICE 02, INVOICE03......)
>> SHIPPING INSTRUCTIONS (only one sheet for this)
>> PACKING LIST (only one sheet for this)
>> COLLECTION NOTE (only one sheet for this)

Plus any extras like Customs Letter etc.



What I would like is to have a chain of commands so that when I press a created button, it saves the unhidden INVOICE / PACKING LIST as a PDF, then saves all visible sheets (minus the "data entry sheets") as a PDF, then prints all visible sheets as hard copies.

Any help is appreciated
Reply With Quote