Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button anomalies | Excel Discussion (Misc queries) | |||
moving mouse highlights cells without touching left mouse button | Excel Discussion (Misc queries) | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
command button moves | Excel Discussion (Misc queries) | |||
How do I setup a spin button in excel | Excel Discussion (Misc queries) |