Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
How can I lock the position of a textbox? | Excel Discussion (Misc queries) | |||
lock button position | Excel Programming | |||
How do I lock a combo box's position once it is placed? | Excel Programming | |||
Lock userform position | Excel Programming |