I have a program that creates excel spreadsheets that have passwords to
protect the code behind. This is preventing users from adding their own
macros because when you go to record a new macro, it asks for the vba
project password. Is there any way to get around this?

No, not in the same workbook if you have protected the project.

When they record their macros, they could choose to use a "new workbook" or
the Personal workbook. but you can't use thisworkbook

--
Regards,
Tom Ogilvy


"ckoch" wrote in message
oups.com...
I have a program that creates excel spreadsheets that have passwords to
protect the code behind. This is preventing users from adding their own
macros because when you go to record a new macro, it asks for the vba
project password. Is there any way to get around this?

I see. That works for me. Do you know under what circumstances you
would get this message when trying to record a new macro and selecting
Personal Workbook?
"Personal macro workbook in the startup folder must stay open for
recording"

I have never run into it, but I recall it being discussed in this newsgroup.
You might try google groups and see it you can find some past discussions.

--
Regards,
Tom Ogilvy

"ckoch" wrote in message
oups.com...
I see. That works for me. Do you know under what circumstances you
would get this message when trying to record a new macro and selecting
Personal Workbook?
"Personal macro workbook in the startup folder must stay open for
recording"

Are you using xl2002+?

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.

ckoch wrote:

I see. That works for me. Do you know under what circumstances you
would get this message when trying to record a new macro and selecting
Personal Workbook?
"Personal macro workbook in the startup folder must stay open for
recording"

--

Dave Peterson

Saving macros to the Personal.xls workbook makes sense, but I'm getting
that same error message when I try to save to the Personal.xls:

"Personal macro workbook in the startup folder must stay open for
recording"

There is nothing in the "Disabled Items" window (earlier post) so
that's not it.
I thought the problem was that I was opening a second instance of
Excel, but even when I don't it's not working. Anyone have anything
further?