Add a button to run a command in a cell

[dawondr]

I had this post in general question but it might be better severed here.
Hi, I was helped by a few great members of the forum to create an email based on cells in my Excel. For reference if needed that post was on https://www.excelforum.com/excel-for...ml#post5715764
Everything works great but instead of seeing the command link it creates in cell B7 I wanted to make a button that I could press to have it run that command. I'm not sure how to do it since it isn't VBA? I'm hoping it is a simple request. So on the attached if I click the button I have pasted in B10, can it run the command in B7?
Any help would be greatly appreciated.

Dave

[PeteABC123]

You'll need a macro to select B7 and enable send

Developer Tab
Insert
Form Controls
Button
(Rename and assign Macro.) Reposition as needed.

A macro would be:

Please Login or Register  to view this content.

Save file as .xlsm

Pete

[Croweater]

Maybe assign this macro to your button?

Please Login or Register  to view this content.

[dawondr]

That did it!!! thank you very much!!!

Dave