Cannot view visual basic functions

[Arthur Richards]

I have had a spreadsheet emailed me which has some VB functions included.

I need to look at this code but I see nothing in the VB editor. The
spreadsheet seems to use these custom functions correctly.

Is there some trick to saving spreadsheets such that the VB code can be
inspected on another PC?

Thanks,
Arthur

 

[Dave Peterson]

Next time you're in the VBE, can you show your project. Then expand it to see
all its components.

If you tried to expand the project components and are prompted for a password,
then the developer locked it.

 

[Arthur Richards]

Thanks Dave.

Problem solved.
I did not realize that I had to invoke the Project Explorer.

Regards
Arthur

 

[Shopper]

Sometime, the code is within a "FORM". Right-click on the Form and choose
"View Code" to see the code.

Thanks Dave.

Problem solved.
I did not realize that I had to invoke the Project Explorer.

Regards
Arthur