printing sheet formulas

[Guest]

I need to print an Excel application which consists of many files that contain formulas, macros and add-ins. First, I want to print all formulas contained in a file (not the contents of the cells but the formulas) so that I can have a "blueprint" of the application as it is referencing multiple sheets and column names etc. I want to do this one file at a time. Then I want to examine the contents of the add-in that was created by the company many years ago aka not a Microsoft addin. Where can I go to see the contents and what the addin is doing? Everywhere I have been shows nothing.

 

[Dave Peterson]

do this against a copy of the workbook, so you don't screw up the columnwidths
in the real workbook.

Tools|options|View Tab
check the Formulas checkbox.
(ctrl ~ (shift backquote on my USA keyboard--left of the 1/! key) is the
shortcut toggle for this)

Widen the columns as required.

David McRitchie has a nice user defined function at:
http://www.mvps.org/dmcritchie/excel/formula.htm
(with lots of notes)

Function GetFormula(Cell)
GetFormula = Cell.Formula
End Function

You could insert one row and put a formula like this in each cell in the row:

=getformula(b1)

If your formulas are consistent, you can see one formula (usually enough) and
see all the data, too.

If you're new to macros, David McRitchie also has some notes at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

========
Load the .xla file.

I'm guessing that you want to see the code behind the .xla.

Hit alt-F11 and you'll be in the VBE where macros live.
hit ctrl-R to open the project explorer
use the + signs to expand the branches of all the open projects. If you're
prompted for a password, you might be stopped--unless you know it!

once you find the project associated with your .xla file, hit F4 to see the
properities window.

Now scroll down that list and look for "isaddin". Make that false.

Now you can see the worksheets (in case there's something useful there, too.)

But you can look under the modules/worksheets/thisworkbook/class
modules/userforms to your heart's content.