Hi,
In a recent post I asked about Stephen Bullens excellent vba indenter.
This is about another Stephen Bullen program... CallTree.
I downloaded it and tried opening it in Excel 2007 and got an error message about an activex control.
The VBA project was deleted.
I've tried emailing Stephen a couple of times but gotten no reply.
Information from the vba indenter post is that Stephen may have retired.
Has anyone anyy help for CallTree please?
I'm particularly interested in the code if it's possible to look at.
TIA
Lisa
CallTree
-
- Administrator
- Posts: 78642
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: CallTree
As you have found, it is impossible to open the workbook in Excel 2007 or later and keep the code. Even if you hold down the Shift key while opening the workbook, the VBA project is removed. So the only way to look at the code - if it is possible at all - would be to find a computer with Excel 2003 or an even older version and to open the workbook there.
Best wishes,
Hans
Hans