Personal.xls "Before Print"
 

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

Personal.xls "Before Print"
 

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

"CLR" wrote:

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

Personal.xls "Before Print"
 

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

Should provide the tools you need.

--
Regards,
Tom Ogilvy

"CLR" wrote in message
...
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

Personal.xls "Before Print"
 

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...s_applica.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"CLR" wrote in message
...
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

Personal.xls "Before Print"
 

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


"Frank Kabel" wrote in message
...
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

"CLR" wrote:

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

Personal.xls "Before Print"
 

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

Vaya con Dios,
Chuck, CABGx3




"Tom Ogilvy" wrote in message
...
http://www.cpearson.com/excel/vbe.htm

Should provide the tools you need.

--
Regards,
Tom Ogilvy

"CLR" wrote in message
...
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

Personal.xls "Before Print"
 

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




"Dick Kusleika" wrote in message
...
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...s_applica.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"CLR" wrote in message
...
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

Personal.xls "Before Print"
 

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 wrote:

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



--

Dave Peterson

Personal.xls "Before Print"
 

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




"Dave Peterson" wrote in message
...
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 wrote:

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



--

Dave Peterson