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)
--
Kris

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" wrote:

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)
--
Kris

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

Cheers, Kris

"Raza" wrote:

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" wrote:

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)
--
Kris

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"krispylala" wrote in message ...
Thanks Raza, answered my question perfectly, sorry i forgot to tell you the
version i was running.

Cheers, Kris

"Raza" wrote:

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" wrote:

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)
--
Kris