Personal Macro Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 29 Dec 2005 14:00 GMT

Good Morning All,
Using Excel and Windows XP.

I want to record a macro and place it in the Personal Macro Workbook. When
I click ok I get an error message "Personal macro workbook in the startup
folder must stay open for recording" and then another message "unable to
record". I've recorded personal macros before and never received that
message. Not sure why that message pops up.

Also the macro record box doesn't show up on the screen, how do I get it
back?

Thanks for your help.

Michael

Reply to this Message

Dave Peterson - 29 Dec 2005 14:25 GMT

Maybe personal.xls was disabled...

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

> Good Morning All,
> Using Excel and Windows XP.
[quoted text clipped - 11 lines]
>
> Michael

Signature

Dave Peterson

Reply to this Message

Mike - 29 Dec 2005 14:41 GMT

Dave,
Yes it was disabled for some reason. Got it working fine. Thanks for your
help. Also I got the stop recording button to show up on the screen.
Michael

> Maybe personal.xls was disabled...
>
[quoted text clipped - 30 lines]
>>
>> Michael

Reply to this Message