Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which sheet will be printed?
Hello Gurus!
Is there a way to know which sheet is going to print? I want to add a code to Cell A1 before the sheet is printed. by creating an Addin I can do it if the user prints the active sheet. But in case the user prints a sheet by using code like sheets("Sheet2").printout and running it from sheet1 then how I cud enter a value in cell A1? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which sheet will be printed?
When a sheet is printed, it becomes the activesheet, albeit temporarily, so
you can address the activesheet wherever it is done from. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Saniya" wrote in message oups.com... Hello Gurus! Is there a way to know which sheet is going to print? I want to add a code to Cell A1 before the sheet is printed. by creating an Addin I can do it if the user prints the active sheet. But in case the user prints a sheet by using code like sheets("Sheet2").printout and running it from sheet1 then how I cud enter a value in cell A1? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop excel sheet from being printed | Excel Discussion (Misc queries) | |||
Subtotals for printed sheet? | Excel Discussion (Misc queries) | |||
Printed multiple pages per sheet | Excel Discussion (Misc queries) | |||
protect a sheet from being printed? | Excel Discussion (Misc queries) | |||
code for showing a sheet has been printed | Excel Worksheet Functions |