print after macro run?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shital shah - 11 Jan 2005 13:35 GMT

hi to all
I have record a macro for advance filter, from run macro from tools. i want
when i print a sheet after print it should run that macro automatically.

thanks

Shital

Reply to this Message

David McRitchie - 15 Jan 2005 22:41 GMT

Hi Shital,
I expect you could use BEFORE print event macro.
http://www.mvps.org/dmcritchie/excel/event.htm

Or write/record a macro to print and then do what you want to do
after printing.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> hi to all
> I have record a macro for advance filter, from run macro from tools. i want
[quoted text clipped - 3 lines]
>
> Shital

Reply to this Message