Forum Discussion

Brandon Lam's avatar
Brandon Lam
Copper Contributor
Mar 13, 2018

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 ...
Macros & VBA
Need Help
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Mar 13, 2018

Hi Brandon,

 

To figure out how to help you, we have to see that macro.

Also, we have to know the structure of the workbook, how many sheets in it, and where you put the button?

 

Please save the workbook as .xls format, and upload it here in a reply.

Why .xls?

As the community policy, .xlsm isn't allowed to be uploaded!

Brandon Lam's avatar
Brandon Lam
Copper Contributor
Mar 13, 2018

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's avatar
    Haytham Amairah
    Silver Contributor
    Mar 13, 2018

    Hi Brandon,

     

     

    The macro isn't found in this workbook!
    It seems it saved in another workbook such as Personal Macro Workbook.

      • Haytham Amairah's avatar
        Haytham Amairah
        Silver Contributor
        Mar 14, 2018

        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!

Resources