was having a discussion today with a couple of people about the options for
storing a macro when you record it - the personal macro workbook & this
workbook made sense to us, but we were stumped for a realistic example of
when you would store a macro in a "new workbook" ... has anyone done this?
if so, what was the rationale behind this choice?

thanks
JulieD

Say I am happy with what's in my personal workbook.
(it's empty :)

But i want to try something..

I ALWAYS record in new workbook
I'll record 10 things.. edit some.. weed out the mistakes
THEN when i'm happy with what I've got, I will decide how to name it and
where to put it. That way i dont get 150 modules in my personal workbook..


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"JulieD" wrote:

was having a discussion today with a couple of people about the
options for storing a macro when you record it - the personal macro
workbook & this workbook made sense to us, but we were stumped for a
realistic example of when you would store a macro in a "new workbook"
... has anyone done this? if so, what was the rationale behind this
choice?

thanks
JulieD

thanks ... i can see how that would work ... but i just do that in "this
workbook" ... i guess it depends on how much running the macro "messes" up


"keepITcool" wrote in message
...
Say I am happy with what's in my personal workbook.
(it's empty :)

But i want to try something..

I ALWAYS record in new workbook
I'll record 10 things.. edit some.. weed out the mistakes
THEN when i'm happy with what I've got, I will decide how to name it and
where to put it. That way i dont get 150 modules in my personal workbook..


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"JulieD" wrote:

was having a discussion today with a couple of people about the
options for storing a macro when you record it - the personal macro
workbook & this workbook made sense to us, but we were stumped for a
realistic example of when you would store a macro in a "new workbook"
... has anyone done this? if so, what was the rationale behind this
choice?

thanks
JulieD

If you don't want to store the macro in the personal.xls or the workbook
where you perform the actions recorded, then you would use the new workbook
option.

--
Regards,
Tom Ogilvy

"JulieD" wrote in message
...
was having a discussion today with a couple of people about the options
for
storing a macro when you record it - the personal macro workbook & this
workbook made sense to us, but we were stumped for a realistic example of
when you would store a macro in a "new workbook" ... has anyone done this?
if so, what was the rationale behind this choice?

thanks
JulieD

I always use Personal for macros that other workbooks (of
mine) will use. I gotta admit, I have no idea what you
mean by "new workbook".
-----Original Message-----
was having a discussion today with a couple of people
about the options for
storing a macro when you record it - the personal macro
workbook & this
workbook made sense to us, but we were stumped for a
realistic example of
when you would store a macro in a "new workbook" ... has
anyone done this?
if so, what was the rationale behind this choice?

thanks
JulieD


.

Why would you want to if Personal is already available.
With a "new" workbook" you would have to set up references
to it. Too much trouble, UNLESS you want to distribute the
macros to other computers.
-----Original Message-----
If you don't want to store the macro in the personal.xls
or the workbook
where you perform the actions recorded, then you would use
the new workbook
option.

--
Regards,
Tom Ogilvy

"JulieD" wrote in message
...
was having a discussion today with a couple of people
about the options
for
storing a macro when you record it - the personal macro
workbook & this
workbook made sense to us, but we were stumped for a
realistic example of
when you would store a macro in a "new workbook" ... has
anyone done this?
if so, what was the rationale behind this choice?

thanks
JulieD




.