Creating button as cell

  • Thread starter Thread starter jpizzle
  • Start date Start date
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
 
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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top