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

[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

 

[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

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.

 

[TomP]

That worked!!! Thank you for your help!

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.