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