Creating button as cell

J

jpizzle

This may be a silly easy question, but im new to Excel so Id appreciat
someone's help. I was wondering if its possible to create a butto
such that the button is a cell itself. So that when you click th
cell, it executes the macro assigned to the button. Also, the butto
would need to keep the size and coordinates of the cell to which it i
created into. If Im not being clear please let ,me know. Thank
 
D

Dave Peterson

You can put a button from the Forms toolbar over that cell. If you rightclick
on the button and choose format control|properties tab, you can specify that it
move and size with cell.

And if you position the edges of the button while holding the alt-key, the
button will "snap-to" the edge of the cell.

(Rightclick on the button and then assign macro will assign the macro to the
button.)
 
Top