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