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