I create a new Excel spreadsheet for various purposes about once per
year. Inevitably, after I figure out all the commands and functions I
want to utilize for one spreadsheet, I forget everything by the time I
start a new spreadsheet. Thus this question....
How do I insert a button into a cell that, when pushed, will run a
macro?
I basically have a project tracking spreadsheet and want to put dates
in a cell when a task is complete. I want a button in the corner of
the cell that will insert the current date and alert the user that he
is changing a date if the button is presed with a date in the cell.
I can write the macro, but I can't for the love of me remember how to
insert the button and link the macro to it. I know I've done this
before.
Thanks for any help.....
--
Robb W
------------------------------------------------------------------------
Robb W's Profile:
http://www.excelforum.com/member.php...o&userid=33908
View this thread:
http://www.excelforum.com/showthread...hreadid=536853