Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button position and screen resolution
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button position and screen resolution
I think this workbook event code might do what you want (change the cell
assignment to the cell you actually want to "attach" to)... Private Sub Workbook_Open() Dim R As Range Set R = Range("D4") With ActiveSheet.CommandButton1 .Left = R.Left + R.Width .Top = R.Top End With End Sub To implement it, right click the XL icon to the left of the File menu item and select View Code from the popup menu that appears and copy/paste the above code into the code window that appeared. Now, whenever the workbook is opened (and macros are enabled), the button will move into position next to the specified cell. -- Rick (MVP - Excel) "Palpha32" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where is toolbar command button to change percentage of screen? | Excel Discussion (Misc queries) | |||
command button position | Excel Discussion (Misc queries) | |||
Command Button Position | Excel Discussion (Misc queries) | |||
Screen Resolution | Excel Programming | |||
Screen Resolution | Excel Programming |