Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to print a master sheet together with another sheet | Excel Discussion (Misc queries) | |||
VBA to count rows in a sheet and increase counter on another sheet then print | Excel Programming | |||
How do I copy a print format from sheet to sheet in excel ? | Excel Discussion (Misc queries) | |||
I want to print out the sheet tabs (sheet names) | Excel Worksheet Functions | |||
after each print, copy data from sheet 1 to sheet 2 | Excel Programming |