Personal.xls "Before Print"

[Guest]

Hi All......

Is it possible to write a Macro to keep in my Personal.xls file, that will
take my "Before Print" macro from my Personal.xls file and install it as a
"Before Print" macro in whatever Workbook I might have open?.......or any
other way to make my Personal.xls "Before Print" macro to work on any open
workbook, so that when that file is re-saved, the "Before Print" macro will
be therein.

TIA for your thoughts.

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Hi
why not create a new workbook template (*.xlt file) which contains your
beforeprint event macro already and base your furture files on this workbook

 

[Tom Ogilvy]

http://www.cpearson.com/excel/vbe.htm

Should provide the tools you need.

 

[Dick Kusleika]

Chuck

Another way: in Personal.xls create a class module with application level
events.

http://www.cpearson.com/excel/AppEvent.htm
http://www.dicks-blog.com/excel/2004/06/classes_applica.html

 

[CLR]

Thanks Frank........yes, that works fine for new WorkBooks, but I also want
to be able to modify any existing WorkBook I might open, modify, and
re-use........

Right now, I just open the existing WorkBook and then do Tools > Macro >
Macros and run the macro out of a module in my Personal.xls Book..........of
course it only runs the macro once, rather than installing it as a
Before-print macro, which is what I really want to do by macro
control............what I'm doing, is using the Before-print macro to create
a footer giving full path and filename and username of the
computer.........this way, when reviewing hard copies printed by others, I
know exactly where it came from, and whether it's potentially
modified........users can of course delete or modify the footers but once
they print it out, back comes my custom footers......

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Thanks for the lead Tom.........I'll check it out.........

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Thanks Dick.........it looks very interesting at first glance but I must
re-read when I'm "awake"..........bedtime now

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

You may want to look at the way John Walkenbach did it in his AddPath routine:

http://j-walk.com/ss/excel/files/addpath.htm

 

[CLR]

Thanks Dave..............that is pretty neat,.............of course it's
'way over my head how it works, but maybe I can get in there and muck about
a bit..........

Vaya con Dios,
Chuck, CABGx3