Can't Trace a Code/Instructions ....

T

TomP

Hello:

I have a spreadsheet with a button that is set to hyperlink. The button
works. When I open the file (macro disabled) and right-click on the button,
there is no option to view the code assigned to it. I can only change the
color, fonts, alignment, etc...

Question: Is there a way I trace the instructions writton for that button?

Thank you,

Tom
 
R

ruve1k

Hello:

I have a spreadsheet with a button that is set to hyperlink. The button
works. When I open the file (macro disabled) and right-click on the button,
there is no option to view the code assigned to it. I can only change the
color, fonts, alignment, etc...

Question: Is there a way I trace the instructions writton for that button?

Thank you,

Tom
Click to expand...

Right click on the button and select Assign Macro. This will allow you
to see which macro is being run by that button. Then open up the VB
editor and locate that macro's code.
 
Top