View hidden workbook that's not on the "list" to unhide?

[Oppressed1]

I'm stepping through the Walkenbach PUP utility code (at the moment, just the part linkfind.utl, the link finder) to learn and "borrow" techniques for other projects. I bought the product and also bought the source code, so John provided the VBA password to permit this very thing. This is all on the up and up.

So I can walk the code; I've even added and saved minor things like StatusBar updates. There's one thing I can't do though, which is see the workbook itself in Excel (I can get to its form, but not the workbook and worksheet). He uses a - I'm sure I'll use the wrong term - invisible or hidden workbook. That workbook is not shown when I go window/unhide. I see personal.xls, but not linkfind.utl.

One more point, the product works from an .XLA which perhaps is not intended for public consumption, paid or not.

I'm not asking to crack something that I'm not supposed to be able to enter. I just want to follow along better because he uses that workbook to collect values and the code logic branches depending on what's in sheet1. So my question is: can I
- view the workbook or copy it to a standard .XLS so I can follow along
or should I
- leave it alone because such a design requires cracking techniques to view.

I'm hoping that there's just some other place I haven't discovered where I can enter the password making the cells become visible. (I can deduce what it's doing while walking code, but more slowly and clumsily than if I can see the cells and follow along. Maybe John will see this when Googling his name and advise. John Walkenbach. John Walkenbach!)

-----
Here are more details of its layout if it clarifies:

- After entering password, I can see ThisWorkbook under LINKFIND.UTL in the Control-R project window in VBA
- I can see ThisWorkbook in the Properties window in VBA, and all its properties.
- I can put ThisWorkbook in the watch window and expand.
- I can see that it has one worksheet Sheet1.
- I can see sheet1 and all its properties in the Properties window in VBA.

By the way, the sheet1 .Visible property is xlSheetVisible.

SO: this is NOT a matter of a hidden worksheet, as I understand it.

Thanks.

[dominicb]

Good afternoon Oppressed1

Yes, you can view the workbook. This is not cracking – you paid for the source code so everything is available, you just need to know how to expose it.

I’m working from memory now, as I don’t have PUP installed on this machine, but from the VBE you need to select the ThisWorkbook within the PUP project and from the Properties window look for the IsAddIn property. This will (obviously) currently be set to True. Just change it to False and the worksheets will be visible. DO NOT save this workbook from the main Excel window, or it will save with the property set to “False”, which you don’t really want.

HTH

DominicB

[Oppressed1]

WAY. TO. GO. That is 100% the solution. Wish you were on here every time I ask a question!