Excel Shared Wrkbk VBA code not viewable

[Tigerlili3]

I have an excel workbook that is shared and when I open it and try to view the vba code, I get a message box stating that the project is locked and is not viewable. It does not list an error number. Does anyone know what could cause this and how to remedy the situation?

Thanks!

 

[PHV]

what could cause this
Seems that the VBAProject is protected.
how to remedy the situation
Ask the owner.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Tigerlili3]

We are the owners...
It turns out that the shared status of the workbook prevents viewing of the code. Removing the shared status allows the code to be viewed. Problem solved!

 

[xlbo]

Have a think about using Access rather than shared workbooks - they're a nightmare

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[Tigerlili3]

It is actually in the process of being converted to Access. I did not create the situation. I inherited it from my predecessor.