new macro problem with password protected worksheet

[ckoch]

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?

 

[Tom Ogilvy]

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

 

[ckoch]

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"

 

[Tom Ogilvy]

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.

 

[Dave Peterson]

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.

 

[MasterMine]

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?