#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
HI,
Would it be possible for you to attach a file so that we do not need to replicate it? |
#3
|
|||
|
|||
Hi Terrymac
Best thing to do would be to record macros for exactly want you want to do for each page (separately for each) Then you can: 1. Call the macro from your own code Call Macro1 2. Cut and paste the recorded code into your own my stuff my stuff my stuff recorded stuff recorded stuff recorded stuff recorded stuff my stuff my stuff my stuff my stuff 3. Add buttons to run the code Developer > Insert > Button - and put in the macro name |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copying specific cells to a new sheets also give sheetname | dapeamel | Excel | 0 | 02-24-2015 09:20 AM |
Print Area - setting Print Area on large sheets | nfotx | Excel | 2 | 12-27-2014 10:21 PM |
Print attachment when it arrive in specific folder with specific subject | visha_1984 | Outlook | 1 | 01-30-2013 10:42 AM |
Print Multiple Sheets Double-Sided | flambe99 | Excel | 1 | 03-12-2010 01:15 PM |
Excel 2007 doesn't print color graphics on multiple sheets | mwoolf | Excel | 1 | 06-19-2009 02:34 AM |