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

Hi Petros,

Try assigning the following code to your button:

'=============
Public Sub ATest01()
Sheets("Sheet2").PrintOut copies:=3
End Sub
'<<=============


---
Regards,
Norman


"petros89" wrote in
message ...

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