ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Lock Button Position (https://www.excelbanter.com/excel-programming/421337-lock-button-position.html)

Risky Dave

Lock Button Position
 
Hi,

I have a sheet that uses a set of buttons to control what the user can do.
These buttons are placed on a Navigation page whoch is formatted to look
pretty, 'cos that's what my users like :-)

This all works fine but when the application is opened by different users
with different screen resolutions, the position of the buttons in relation to
the formatting of the page "below" them changes.

Is it possible to "lock" the positions of buttons in relation to specific
cells on a page?

TIA

Dave

Trevor Williams

Lock Button Position
 
Hello again Dave - Have you set the properties of the buttons to 'Don't Move
or Size with Cells'?

(Right click on the button, go to properties, set the option, click ok)

Trevor

"Risky Dave" wrote:

Hi,

I have a sheet that uses a set of buttons to control what the user can do.
These buttons are placed on a Navigation page whoch is formatted to look
pretty, 'cos that's what my users like :-)

This all works fine but when the application is opened by different users
with different screen resolutions, the position of the buttons in relation to
the formatting of the page "below" them changes.

Is it possible to "lock" the positions of buttons in relation to specific
cells on a page?

TIA

Dave



All times are GMT +1. The time now is 10:28 AM.

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