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 |
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 |
All times are GMT +1. The time now is 11:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com