Which sheet will be printed?

[Saniya]

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

 

[Bob Phillips]

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)