Forum Discussion
Brandon Lam
Mar 13, 2018Copper Contributor
Assign a macro to a button
Wondering if someone can help me on this. I have a macro which works perfectly fine when manually triggered or assigning a shortcut key to run it. However, for some strange reason, when i assign the ...
Brandon Lam
Mar 13, 2018Copper Contributor
Here it is. Appreciate your help. The macro in question is the Sub CreateUploadBtn_Click()
Also want to add that Macro worked fine (even by assigning it to a button) with older version of excel. Problem only kicked in when i got upgraded to excel 2016.
Haytham Amairah
Mar 13, 2018Silver Contributor
Hi Brandon,
The macro isn't found in this workbook!
It seems it saved in another workbook such as Personal Macro Workbook.
- Brandon LamMar 14, 2018Copper Contributor
Sorry, my bad. Hopefully this works now.
- Haytham AmairahMar 14, 2018Silver Contributor
Hi Brandon,
I tried to figure out what the issue was but I could not!
Sorry!
I suggest you to ask this https://stackoverflow.com/ it's the best place to go in such an issue!
- Brandon LamMar 19, 2018Copper Contributor
No apologies needed. Appreciate your help!! :)