ADDING A PRINT CONTROL BUTTON

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a work book that i enter everthing on the first sheet and it puts
information in the other sheets in the work book. how can i add a button to
the first sheet to make the other sheets print there are 7 sheets in total i
need for 6 to print when clicking on a button. Could some one tell me if
this is possible thanks
 
Tonya
Since you have 7 sheets and want only six of them printed, Excel will
have to know what the name of the 7th sheet is in order to exclude it.
Also, what range do you want printed in each sheet? Excel can figure this
out (the range to print) if you tell it how. Of course, Excel can simply
print the used range if you wish. Post back with some clarification. HTH
Otto
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Excel Move or Copy Stopped Working? 0
Collapsing all groups 0
Printing Dates on One Sheet 5
Excel Monthly Spread sheet. 12
Reset Button 4
Excel print area which only prints pages of worksheet which are active 0
Match and delete rows on two different sheets from reference numbers 4

Back
Top