Brian,

1) show the "control toolbox" toolbar and there you find a comman
button to "draw" where you want.
then go to the properties and give that button an nice name an
description (caption)
then go to the code of the button and call your macro from there with
call AddData
and exit the design mode (button on the toolbar)

2) and 3) sorry I'm in a hurry..

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements