button to print a sheet

[cid]

Hi
I need help again..
ps thankx robin for helping out last time..
new question
I need to make a macro button that prints out a certain sheet...
I have been trying to make one, but I am hopeless.
cheers
cid

[Gary Keramidas]

have you tried recording a macro while you print what you want to?

tools/macro/record new macro

then print your sheet.
stop recording

then click on view/toolbars
select forms
click the command button
draw it where you want it on the sheet.
a dialog will pop up asking you to asking a macro
choose the one you just recorded
click ok
type the name of the button where it says button 1
close the toolbar and you should have a button with a macro assigned to it

--


Gary


"cid" <[email protected]> wrote in message
news:[email protected]...
>
> Hi
> I need help again..
> ps thankx robin for helping out last time..
> new question
> I need to make a macro button that prints out a certain sheet...
> I have been trying to make one, but I am hopeless.
> cheers
> cid
>
>
> --
> cid
> ------------------------------------------------------------------------
> cid's Profile:
> http://www.excelforum.com/member.php...o&userid=25582
> View this thread: http://www.excelforum.com/showthread...hreadid=390086
>

[Gary Keramidas]

"asking a macro" s/b "assign a macro"

--


Gary


"Gary Keramidas" <[email protected]> wrote in message
news:[email protected]...
> have you tried recording a macro while you print what you want to?
>
> tools/macro/record new macro
>
> then print your sheet.
> stop recording
>
> then click on view/toolbars
> select forms
> click the command button
> draw it where you want it on the sheet.
> a dialog will pop up asking you to asking a macro
> choose the one you just recorded
> click ok
> type the name of the button where it says button 1
> close the toolbar and you should have a button with a macro assigned to it
>
> --
>
>
> Gary
>
>
> "cid" <[email protected]> wrote in message
> news:[email protected]...
>>
>> Hi
>> I need help again..
>> ps thankx robin for helping out last time..
>> new question
>> I need to make a macro button that prints out a certain sheet...
>> I have been trying to make one, but I am hopeless.
>> cheers
>> cid
>>
>>
>> --
>> cid
>> ------------------------------------------------------------------------
>> cid's Profile:
>> http://www.excelforum.com/member.php...o&userid=25582
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=390086
>>
>
>