PC Review


Reply
Thread Tools Rate Thread

A button on one sheet to print other sheets

 
 
=?Utf-8?B?RXdvdXQ=?=
Guest
Posts: n/a
 
      22nd Sep 2006
I have an excel file with one hundred graphics. The data for the graphics are
put in the very first sheet. Behind the data I would like to have a button to
print out the graphics sheet that the data refer to. So I don't have to go to
the graphics sheet every time, and click the right button there.
--
Ewout
 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWFyY2Vsbw==?=
Guest
Posts: n/a
 
      22nd Sep 2006
hi Ewout,

you can create a button and excel will record the macro for you.
hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Ewout" escreveu:

> I have an excel file with one hundred graphics. The data for the graphics are
> put in the very first sheet. Behind the data I would like to have a button to
> print out the graphics sheet that the data refer to. So I don't have to go to
> the graphics sheet every time, and click the right button there.
> --
> Ewout

 
Reply With Quote
 
=?Utf-8?B?RXdvdXQ=?=
Guest
Posts: n/a
 
      22nd Sep 2006
I know, I already made the buttons. But how do I record the macro?
--
Ewout


"Marcelo" wrote:

> hi Ewout,
>
> you can create a button and excel will record the macro for you.
> hth
>
> --
> regards from Brazil
> Thanks in advance for your feedback.
> Marcelo
>
>
>
> "Ewout" escreveu:
>
> > I have an excel file with one hundred graphics. The data for the graphics are
> > put in the very first sheet. Behind the data I would like to have a button to
> > print out the graphics sheet that the data refer to. So I don't have to go to
> > the graphics sheet every time, and click the right button there.
> > --
> > Ewout

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print a sheet using a button Mangler Microsoft Excel Discussion 4 13th Feb 2009 09:37 PM
Macro button to print sheets populated from drop-down list AB3 Microsoft Excel Misc 7 11th Jul 2008 01:03 AM
Create a Button that will print sheets Helen Microsoft Excel Programming 2 15th Nov 2005 02:01 AM
button to print a sheet cid Microsoft Excel Programming 2 26th Jul 2005 05:34 AM
Print Worksheet on A2 sheet using 4x A4 sheets? Gunjani Microsoft Excel Misc 1 8th Apr 2004 02:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:45 PM.