ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Keeping Control Buttons Still (https://www.excelbanter.com/excel-worksheet-functions/60380-keeping-control-buttons-still.html)

ZipCurs

Keeping Control Buttons Still
 
I have created an interface sheet with a number of control buttons on it. I
do not want the buttons to move or change size. I have set the properties to
"Don't Move or Size with Cells" and have the "Print" box unchecked. The
control buttons still move if the one of the adjacent cells changes its row
height (i.e. wrapped text). Any thoughts or help.

ZipCurs

Keeping Control Buttons Still
 
It turns out that it was inserting and deleting rows behind the control
buttons was the problem. I have fixed the problem by not inserting or
deleting cells behind the buttons.

"ZipCurs" wrote:

I have created an interface sheet with a number of control buttons on it. I
do not want the buttons to move or change size. I have set the properties to
"Don't Move or Size with Cells" and have the "Print" box unchecked. The
control buttons still move if the one of the adjacent cells changes its row
height (i.e. wrapped text). Any thoughts or help.



All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com