Software

Ask something
Question Locked

EXCEL Macro query

0 helpful
2 replies

by dcleary

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

After assigning several macros to different buttons in EXCEL 2003, How can I identify which macro is assigned to which button.

Is this possible? - its certainly not straight forward with a right click or anything like that.

Is there a registry setting that hold this information?

I have recently acquired a database with a complex Macro that needs transferring to another PC but I need t identify what the macro is as it is only run through a click of a button and there are many macro buttons....!!

Thanks

2 replies

by james_r_harrod

If you know how to code VBScript, you can write code which loops through each button in the Sheet, selects it and then displays the macro assigned.

Would it be possible to send me your file? Just to that I can see the code?

This discussion is closed to new replies.