Add Button to Cell

  • Thread starter Thread starter MIke
  • Start date Start date
M

MIke

I have two questions:

A/ Can I add a button to a cell in my worksheet that will
sort the column data? Like the Assending/Descending
buttons on the toolbar above the sheet. Basically, can I
add those buttons to a cell?

B/ Can I have Excel mail me when a date within the
worksheet is getting close, or overdue, etc..?

Thank you for your assistance. I've researched both of
these in other places, and found the answer to be no to
both questions, but I figured I'd ask the experts to get
the final answer.

Mike
..
 
Turn on the macro recorder and sort a range.

turn off the macro recorder.

Make the forms toolbar visible, click on a button and rubberband an area on
the worksheet. Assign you macro to the button.

Go to the macro and modify it to perform exactly as you want.

Repeat if you want another button or copy the existing button, copy the
existing macro and change the appropriate elements.

then assign the new macro to the copy of the button.

Information on mailing from excel:


Ron de Bruin
http://www.rondebruin.nl/sendmail.htm
http://msdn.microsoft.com/library/en-us/odc_xl2003_ta/html/odc_xlmail.asp

Dick Kuselika
www.dicks-clicks.com

Tim Zych
www.rubbershoe.com/olmail.htm
 
Back
Top