when would you use "new workbook"

[JulieD]

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

 

[keepITcool]

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]

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

 

[Tom Ogilvy]

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.

 

[SidBord]

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".

 

[SidBord]

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.