I have a VBA project that I created for my worksheet. WHen
I try to view it in the Microsoft Visual Basic Editor, the
following error message may appear

Project Locked
Project is unviewable

even though I did not lock the project for viewing in the
properties for the project. This message also appears if I
click VBAProject Properties on the Tools menu in the
Microsoft Visual Basic Editor.

I read Microsoft Knowledge Base Article - 211792, which
says that this occurs due to workbook sharing -- except
that this is not a shared workbook.

The macros work fine, but I cannot edit them anymore. How
do I unlock my project so I can continue to work on them?

"Eric L. Vogel" wrote in message ...
I have a VBA project that I created for my worksheet. WHen
I try to view it in the Microsoft Visual Basic Editor, the
following error message may appear

Project Locked
Project is unviewable

even though I did not lock the project for viewing in the
properties for the project. This message also appears if I
click VBAProject Properties on the Tools menu in the
Microsoft Visual Basic Editor.

I read Microsoft Knowledge Base Article - 211792, which
says that this occurs due to workbook sharing -- except
that this is not a shared workbook.

The macros work fine, but I cannot edit them anymore. How
do I unlock my project so I can continue to work on them?


Can you export the code modules?

Unfortunately, the Export option is disabled in the File menu.

Eric


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

<<except that this is not a shared workbook.

Presumably you have checked File/Save As/Options ? (Just a thought)


Regards
BrianB
----------------------------------------------------




"Eric L. Vogel" wrote in message ...
I have a VBA project that I created for my worksheet. WHen
I try to view it in the Microsoft Visual Basic Editor, the
following error message may appear

Project Locked
Project is unviewable

even though I did not lock the project for viewing in the
properties for the project. This message also appears if I
click VBAProject Properties on the Tools menu in the
Microsoft Visual Basic Editor.

I read Microsoft Knowledge Base Article - 211792, which
says that this occurs due to workbook sharing -- except
that this is not a shared workbook.

The macros work fine, but I cannot edit them anymore. How
do I unlock my project so I can continue to work on them?

I did check File Save As, saved a new copy, with the same result in the
copy. There were no options in Save As that had any effect.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!