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


.