when would you use "new workbook"
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
.
|