View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_763_] Leith Ross[_763_] is offline
external usenet poster
 
Posts: 1
Default Command button position and screen resolution


Palpha32;256211 Wrote:
I have a worksheet that has four command buttons to run macros. If it
is
used on a computer with a different screen resolution the buttons are
in a
different position. Is there a way of anchoring the buttons to a point
on
the worksheet so that they are in the same position, relarive to the
cells,
no matter what the resolution?
Thanks in advance for your help.

Regards
Peter


Hello Peter,

If the command buttons are from the Control Toolbox then you can the
following:

1. Right Click the command Button.
2. Select Format Control...
3. Select the Properties tab
4. Click the check box marked Move and size with cells


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71514