View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cimbom cimbom is offline
external usenet poster
 
Posts: 11
Default How to put a button on a cell and assign macro to it?

Hi,

I would like to put a button on top of each column so that when I
click on the button, it will do the basic sort function. I would like
to sort each machine by first x (employees who know the job) second Y
(wants to be contacted) and third by seniority ( oldest to
newest) .
A B C D
E F G
1 NAME FED1 FED2 N-8 Contact? Seniority
Phone number
2 Brian x x
Y 8/23/04 234-5678
3 David x
N 5/6/00
4 Roger x x N
6/12/02
5 Jeff x
Y 5/21/01
6 Chad x Y
9/31/04
7 Serhan x x Y
3/15/02 213-2145
8 Garrett x
N 9/10/99
9 Liz x x
N 7/7/03
10 Tom x x
Y 4/3/00 324-6723


So, Fed 1 will basically look like this:

Tom x Y 4/3/00 324-6723
Serhan x Y 3/15/02 213-2145
Brian x Y 8/23/04 234-5678

I, also, would like to go back to the original list after the
sorting.

Thank you,