View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Embedding command buttons in cells

You can use VBA to make it fit exact or you can hold the alt key while you're
positioning the object. With the alt key held down, the object will snap to the
cell's edge.

And do that "move and size" with the cell, too.

And try positioning an object when you hold down the shift key. It'll do
something else that might be useful.

Andy wrote:

Just a thought;

Is it possible to embed a command button within a cell, so that it positions
and resizes accordingly? I'm assuming it would have to be code to specify
this.

Ta

Andy


--

Dave Peterson