Personal Macro Workbook

teddavenport · May 2nd, 2002, 02:19 PM

I want to create and save a macro in my Personal Macro Workbook so I can use it each time I create a new spreadsheet in Excel. When I try to create and save the macro in my Personal Macro Workbook, I get this message and the macro is not saved: "Personal Macro Workbook in the startup folder must stay open for recording." What am I doing wrong? Please help. And thank you in advance.

RET79 · May 2nd, 2002, 02:22 PM

is your personal workbook open while you record the macro? I doubt you could record and save your macro in it if it wasn't open unless someone has some seriously advanced code out there !

Open up your personal book and try agian

RET79

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 02:19 PM	#1
teddavenport New Member Join Date: Apr 2002 Location: Ted Davenport Posts: 10	I want to create and save a macro in my Personal Macro Workbook so I can use it each time I create a new spreadsheet in Excel. When I try to create and save the macro in my Personal Macro Workbook, I get this message and the macro is not saved: "Personal Macro Workbook in the startup folder must stay open for recording." What am I doing wrong? Please help. And thank you in advance.

May 2nd, 2002, 02:22 PM	#2
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	is your personal workbook open while you record the macro? I doubt you could record and save your macro in it if it wasn't open unless someone has some seriously advanced code out there ! Open up your personal book and try agian RET79