View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Malinsky[_3_] Michael Malinsky[_3_] is offline
external usenet poster
 
Posts: 45
Default Put a button in a cell

Put the button where you want it then, while in design mode, right-click the
button and select Format Control. On the Properties tab, select "Don't move
or size with cells" to cause to button to remain in position regardless of
the adding or deleting of cells.

HTH
Mike.

"Christopher Benson-Manica" wrote in message
...
I need a way to put a button in a specific cell (not a button that
floats) that deletes the row that it is on when pressed, from VBA
(since I need to do this iteratively). Is there a way to do it?
Thanks...

--
Christopher Benson-Manica | I *should* know what I'm talking about - if I
ataru(at)cyberspace.org | don't, I need to know. Flames welcome.