Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-16-2015, 04:13 AM
terrymac terrymac is offline How can set a command to print only specific sheets? Windows XP How can set a command to print only specific sheets? Office 2007
Novice
How can set a command to print only specific sheets?
 
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
  #2  
Old 11-21-2015, 12:53 PM
charlesdh charlesdh is offline How can set a command to print only specific sheets? Windows 7 32bit How can set a command to print only specific sheets? Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

HI,

Would it be possible for you to attach a file so that we do not need to replicate it?
Reply With Quote
  #3  
Old 12-01-2015, 05:29 PM
Graham Griggs Graham Griggs is offline How can set a command to print only specific sheets? Windows 8 How can set a command to print only specific sheets? Office 2013
Novice
 
Join Date: Dec 2015
Posts: 11
Graham Griggs is on a distinguished road
Default

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
Reply With Quote
Reply

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
How can set a command to print only specific sheets? 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


All times are GMT -7. The time now is 02:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft