Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Trace a Code/Instructions ....
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Trace a Code/Instructions ....
On Aug 18, 10:05 am, TomP wrote:
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Trace a Code/Instructions ....
That worked!!! Thank you for your help!
" wrote: On Aug 18, 10:05 am, TomP wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Special Print Instructions | Excel Worksheet Functions | |||
can i use one workbook to perform instructions i another | Excel Discussion (Misc queries) | |||
is there a way to do 4 instructions with one macro | Excel Discussion (Misc queries) | |||
click on cell and get instructions, how do you set it up? | Excel Discussion (Misc queries) | |||
trace dependent tool doesn't work but trace precendent doesn't | Excel Discussion (Misc queries) |