button

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

Guest

Hi,
How can i add a button "print" in the top of the worksheet , just to print
first page onle
 
Hi Mohamed,

Select the button icon on the 'Forms' toolbar and place it whereeve
you want it on the sheet. Then right click on the button and selec
'Assign macro'. Then select record and perform the steps required t
print one sheet. Once you are done, stop recording the macro and yo
are good to go.

If you want to generalise it you can analyse the code and make change
to it. (Alt+f11) shows you VB Editor where your macro code is in one o
the Modules.

Regards
RA
 
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
Macro buttons for gray scale and color print 2
Print on only one page 5
Macro to print a selected range, not entire worksheet 3
Printing now not working! 3
Print Button 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
1st 2 rows of wksht show up @ top of each page of the wksht 2

Back
Top