create personal macro workbook

[krispylala]

Hi, have read the posts, but still don't have an answer, i am getting
"Personal Macro Workbook in the startup folder must stay open for recording"
when selecting Personal workbook while trying to create a macro.. I don't
think i have a personal workbook, so can anyone tell me how to create it and
where to store it? unless it has a default home i think.. i want to record
all my macros in it, (i know i have to have it open and hidden each time i
open excel)

 

[Raza]

What version of excel are you running? Here is the information for Windows
users:

Go to C:\Program Files\Microsoft Office\Office\Xlstart (assuming you used
the default location when you installed Office).

Right-click the right pane of Xlstart and choose New, Text Document. Name
your new document personal.xls and press Enter. When asked if you want to
change the extension, click Yes.

Now double-click your new file to open it in Excel. Next, choose Window,
Hide and then choose File, Exit. When asked if you want to save the Personal
macro workbook, click Yes. The next time you run Excel, personal.xls will run
but remain hidden.

To store your macros in personal.xls, choose Window, Unhide to unhide
personal.xls. After you finish storing your macros, choose Window, Hide to
hide personal.xls again.

 

[krispylala]

Thanks Raza, answered my question perfectly, sorry i forgot to tell you the
version i was running.

Cheers, Kris

 

[Ron de Bruin]

See also
http://www.rondebruin.nl/personal.htm