Don, could we take this one step further please. New computer and it's been
a long while since I've had to start from scratch.
When I try to record a macro, I get the message "Personal Macro Workbook in
the startup folder must stay open for recording". All I have in my XLSTART
folder is Personal.xls, that automatically opens when I enter excel, so it is
open. I click OK, hoping to record a macro to "create" the folder. I get is
"Unable to record". There is no file in Window - Unhide. Am I looking in the
wrong place? Elli

"Don Guillett" wrote:

If you do not already have a personal.xls record a macro to personal macro
workbook. When you close excel after that creation you will be asked if you
want to save personal.xls say yes. Now it will be available to you.
However this is a hidden workbook.

--
Don Guillett
SalesAid Software

"Raewyn" wrote in message
...
I have two questions really. First, I was told there was a specific place
to
save a macro if I wanted it to be avalable whenever I opened excel. Where
would that be? Also, how do I create a macro that is always available when
I
open excel instead of spreadsheet specific. Thanks for your help.