Print a sheet without ever selecting the sheet
 

I have a worksheet titled TNT and in this worksheet, I have a button to
print the print area of a sheet that is titled Variables.


Code:
--------------------
Sub PrintVariables()

Sheets("Variables").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("TNT").Select
End Sub

--------------------


I recorded the above macro simply enough, but what I want is to print
the Variables tab without ever selecting the variables tab like it
currently does.

In other words, I want the button that runs this macro to print the
Variables tab without ever leaving the TNT tab.

How do I make the rquired changes?


--
sharkfoot
------------------------------------------------------------------------
sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164
View this thread: http://www.excelforum.com/showthread...hreadid=522334

Print a sheet without ever selecting the sheet
 

try
application.screenupdating=false
before
Sheets("Variables").Select


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522334

Print a sheet without ever selecting the sheet
 

Works perfectly. Thank you very much!


--
sharkfoot
------------------------------------------------------------------------
sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164
View this thread: http://www.excelforum.com/showthread...hreadid=522334

Print a sheet without ever selecting the sheet
 

Sub PrintVariables()
Sheets("Variables").Printout
End Sub

--
Regards,
Tom Ogilvy


"sharkfoot" wrote
in message ...

Works perfectly. Thank you very much!


--
sharkfoot
------------------------------------------------------------------------
sharkfoot's Profile:
http://www.excelforum.com/member.php...o&userid=32164
View this thread: http://www.excelforum.com/showthread...hreadid=522334