Finding out Excel Formula

[Sunden2010]

Hi All,
Hope all is well.
I have an excel doc that has a formula executed when
pressing on a button-like
symbol. Is it possible to find out/view the actual
formula inside this
button? It's not behaving as it should & I'd like to
modify it.
Thanks!

 

[longhair]

sunden2010,
from the menu choose tools, macro, macros & you should see any macros for your open work books.

hth
regards,
longhair

 

[Mizzness]

Sunden2010,

You may also use Alt-F11 to open the VB Editor.

Regards,
Mizzness

 

[SkipVought]

Try right clicking the button. If it's a Form button, it will display an option to show you the name of the macro and you can choose to edit.

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]

 

[Dsuperc]

Try Ctrl+` (That is the key above Tab or at the left of 1)