I'm trying to access some macros that I wrote in a VBA project but I'm
getting a message "Project Locked - Project is unviewable".

This was all done in MS Excel 2002 and MS Visual Basic 6.3 so there should
be no issues with later versions.

I can't even get into Tools-VBAProject Properties to unlock any protection.

Any thought anyone?

Roedd <<hemsterp wedi ysgrifennu:

I'm trying to access some macros that I wrote in a VBA project but I'm
getting a message "Project Locked - Project is unviewable".

This was all done in MS Excel 2002 and MS Visual Basic 6.3 so there
should be no issues with later versions.

I can't even get into Tools-VBAProject Properties to unlock any
protection.

Any thought anyone?

I've seen this if the workbook was saved as shared. Try unsharing it.

--
Rob

The file had been previously shared but was unshared when the problem
occurred. I re-shared and unshared it and it's now fine. Thanks for your
help.

H.

"Robert Bruce" wrote:

Roedd <<hemsterp wedi ysgrifennu:

I'm trying to access some macros that I wrote in a VBA project but I'm
getting a message "Project Locked - Project is unviewable".

This was all done in MS Excel 2002 and MS Visual Basic 6.3 so there
should be no issues with later versions.

I can't even get into Tools-VBAProject Properties to unlock any
protection.

Any thought anyone?

I've seen this if the workbook was saved as shared. Try unsharing it.

--
Rob

I was trying to mail merge when it somehow locked my excel project it now
says unviewable also project locked. Can anyone advise how i can get in and
open this up again. I am not real knowledgeble at my age.
Thanks in advance

"Robert Bruce" wrote:

Roedd <<hemsterp wedi ysgrifennu:

I'm trying to access some macros that I wrote in a VBA project but I'm
getting a message "Project Locked - Project is unviewable".

This was all done in MS Excel 2002 and MS Visual Basic 6.3 so there
should be no issues with later versions.

I can't even get into Tools-VBAProject Properties to unlock any
protection.

Any thought anyone?

I've seen this if the workbook was saved as shared. Try unsharing it.

--
Rob