How to Create a Macro Button in Excel | Assign a Macro to a Button in Excel | Hyperlink to Worksheet

In this video, I demonstrate how to assign a macro to a button in Excel. The video runs you through how to create a simple navigation button that when clicked on hyperlinks to a different worksheet. This method, however, will work for any macro that you have recorded.

I demonstrate two methods for creating a macro button:

1) Using a form control
2) Using shapes
------------------------

[sarahmahmoud]

That was very helpful. You even didn’t forget to mention how to get the developer tap as I didn’t have it and other websites were just going straight ahead to use it without mentioning how to get it
thanks a million.

[pinkkyhag]

Thanks. It's make me understand quickly.

[Crav-n]

How to make a button the automatically copies info to paste in word or another program? Pls help

[abdelazizbouzid]

Hi sir, and thank you so much about your job .
I wish you a good health and happiness.
Please, I have this issue
For example in A1 I put this number 3496788, how can I colouring the first four right digits 6788 with colour ( ex: red colour ) and the rest digits 349 with different colour ( ex: green ) . That means each number putting in A1 will getting in its first right digits a colour ( the number of the first right digits according to our desire one digit, two digits, three digits ...etc ), and the rest digits will getting another colour .
I hope you understand me.
Thank you so much.