Hi, I want to create a macro using VB which prints another sheet...
For example, i have a button on sheet 1, but want to press that button to print 3 copies of sheet 2..can any1 help?
Thanks in advance.
Hi, I want to create a macro using VB which prints another sheet...
For example, i have a button on sheet 1, but want to press that button to print 3 copies of sheet 2..can any1 help?
Thanks in advance.
Hi Petros,
Try assigning the following code to your button:
'=============>>
Public Sub ATest01()
Sheets("Sheet2").PrintOut copies:=3
End Sub
'<<=============
---
Regards,
Norman
"petros89" <[email protected]> wrote in
message news:[email protected]...
>
> Hi, I want to create a macro using VB which prints another sheet...
>
> For example, i have a button on sheet 1, but want to press that button
> to print 3 copies of sheet 2..can any1 help?
>
> Thanks in advance.
>
>
> --
> petros89
> ------------------------------------------------------------------------
> petros89's Profile:
> http://www.excelforum.com/member.php...o&userid=24645
> View this thread: http://www.excelforum.com/showthread...hreadid=489106
>
sub commandbutton1_click()
thisworkbook.sheets(3).printout 3
end sub
--
When you lose your mind, you free your life.
"petros89" wrote:
>
> Hi, I want to create a macro using VB which prints another sheet...
>
> For example, i have a button on sheet 1, but want to press that button
> to print 3 copies of sheet 2..can any1 help?
>
> Thanks in advance.
>
>
> --
> petros89
> ------------------------------------------------------------------------
> petros89's Profile: http://www.excelforum.com/member.php...o&userid=24645
> View this thread: http://www.excelforum.com/showthread...hreadid=489106
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks