How do I put a toolbar button into a worksheet?

[Guest]

I am looking to essentially put the "Create Microsoft Outlook Task" button
(or create a similar button) into a worksheet on a recurring basis. I can
"create / draw" a button but am struggling to establish how to actually make
it function (ie when you click on it the desired "link" happens).

Any help greatly appreciated

Novice ;-)

 

[Guest]

Create the macro to create the task.

On the Form toolbar, choose the option for a button (small grey button) then
right click on it and "assign macro". Assign your macro to it.

Click on it to use.