View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Williams Trevor Williams is offline
external usenet poster
 
Posts: 181
Default 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