Can I view the source code of the macro

Copper Contributor

As see in the attached picture , we have a excel macro that developed by our previous colleagues , we can use the button to search data .

Just would like to know how can I view source code of the macro ? just would like to know the source code of each button .

Thanks allmarco-1.jpg

2 Replies
If you right click on the button, do you see "View code"

@patrickchan15 On the Developer tab you can open the visual base Editor. Her you can find all macro's in the workbook, provided that the author did not protect them with a password.

 

If the Developer tab is not visible, check out the link below on how to enable it.

https://support.microsoft.com/en-us/topic/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d4...