ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Project Unviewable (https://www.excelbanter.com/excel-programming/374282-project-unviewable.html)

hemsterp

Project Unviewable
 
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?

Robert Bruce[_2_]

Project Unviewable
 
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



hemsterp

Project Unviewable
 
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




Curt

Project Unviewable
 
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





All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com