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

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" <gsoniya@gmail.com> wrote in message
news:1129535859.992391.138330@g43g2000cwa.googlegroups.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
>