finding macros/formulas used in a spreadsheet

[jbclem3]

I was sent a spreadsheet and it has various columns whose rows calculate
based on certain criteria. How can I find the formulas or macros that
control these columns. Is there a basic way to do this so I can learn how
they are crafted?

jc

Excel 2002
Windows 2000

 

[Gord Dibben]

To find formulas hit CTRL + `(backquote above Tab key) to toggle "show
formulas".

If you do have Macros they are probably event code behind the worksheet(s).

Right-click on a sheet tab and "View Code". Anything there?

Alt + q to return to Excel.


Gord Dibben MS Excel MVP

 

[jbclem3]

Thanks for the ideas. CTRL ` didn't show any formulas, and View Code also
didn't show any Macros. I also went to tools/macro/macro and "Macros in"
was set to the spreadsheet/worksheet but there were no macros listed.

Under View Code I could see a list of objects and each object(sheet1,
sheet2, etc...) had a short list of properties, although the object called
workbook had a longer list of properties. I tried changing some of them
(false to true) but it didn't seem to make any difference.

This spreadsheet is a stock market spreadsheet that imports data for each
symbol listed (each symbol is a row). Some of the columns must have
formulas in all their cells because they calculate a BUY or SELL result for
the symbols that qualify.

Anyway, so far no sign of anything. You'd think there would have been Code
or Macros all over this spreadsheet. There are internet links in some of the
column heading cells that provide a general explanation of what is being
calculated. I can see those links by placing the cursor over the heading.

This is interesting, but I seem to have picked the wrong spreadsheet to
learn from.

John

 

[Gord Dibben]

If you want to you could send the workbook to me personally at

gorddibbATshawDOTca change the obvious.


Gord