ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel 97, VB project unable to view in another comp (https://www.excelbanter.com/excel-programming/416319-excel-97-vbulletin-project-unable-view-another-comp.html)

CAPTGNVR[_2_]

excel 97, VB project unable to view in another comp
 
Dear ALL

I locked the vb project with the password protection in excel 97.

I could load this saved worksheet in another comp and could see the vb
project by entering the password.

But on one computer running the same excel 97, when i click on the project I
get "project is unviewable" instead of asking for "password".

What could be this reason and how to solve as I need to open the project in
that computer and do the final coding for local paths etc. Pls help

br/captgnvr

sham[_2_]

excel 97, VB project unable to view in another comp
 
make sure macro is enabled and andd reference
"miscrosft visulbasic for application extensibility 5.2"

hope this helps


On Aug 30, 8:48*am, CAPTGNVR
wrote:
Dear ALL

I locked the vb project with the password protection in excel 97.

I could load this saved worksheet in another comp and could see the vb
project by entering the password.

But on one computer running the same excel 97, when i click on the project I
get "project is unviewable" instead of asking for "password".

What could be this reason and how to solve as I need to open the project in
that computer and do the final coding for local paths etc. *Pls help

br/captgnvr



CAPTGNVR[_2_]

excel 97, VB project unable to view in another comp
 
D/SHAM
Thanks for the guidance but too short an explanation.

Anyhow, macro is enabled and unable to ustand how to add reference microsoft
visual basic for application extensibility 5.2??. Do you mind to give me
some more guidance pls?.
br/captgnvr

"sham" wrote:

make sure macro is enabled and andd reference
"miscrosft visulbasic for application extensibility 5.2"

hope this helps


On Aug 30, 8:48 am, CAPTGNVR
wrote:
Dear ALL

I locked the vb project with the password protection in excel 97.

I could load this saved worksheet in another comp and could see the vb
project by entering the password.

But on one computer running the same excel 97, when i click on the project I
get "project is unviewable" instead of asking for "password".

What could be this reason and how to solve as I need to open the project in
that computer and do the final coding for local paths etc. Pls help

br/captgnvr





All times are GMT +1. The time now is 01:59 AM.

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