button moving
 

I have a button on a worksheet that moves when I delete rows. How can I make
it fixed on a page?


--
Thanks
Shawn

place the button on the top row, highlight the cell below it, click on
windows - freeze pane.

"Shawn" wrote:

I have a button on a worksheet that moves when I delete rows. How can I make
it fixed on a page?


--
Thanks
Shawn

Well, since the entire column is deleting it still shifts it over


--
Thanks
Shawn


"Mike" wrote:

place the button on the top row, highlight the cell below it, click on
windows - freeze pane.

"Shawn" wrote:

I have a button on a worksheet that moves when I delete rows. How can I make
it fixed on a page?


--
Thanks
Shawn

Shawn,

Right-click on the button (you have to be in design mode to do this - use
the Control Toolbox menu to do this, or look it up in Help), click on Format
Control, click on the Properties tab, and select "Don't move or size with
cells".

Eric

"Shawn" wrote:

I have a button on a worksheet that moves when I delete rows. How can I make
it fixed on a page?


--
Thanks
Shawn