| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Position
So incredible!
"Chip Pearson" wrote: You'll need to change the size of two arrays: ' CHANGE Dim VCmdArr(0 To 20) As Single ' hold our command bar widths Dim HCmdArr(0 To 20) As Single ' of command bars. ' TO Dim VCmdArr(0 To 50) As Single ' hold our command bar widths Dim HCmdArr(0 To 50) As Single ' of command bars. The code doesn't work in Excel 2007 due to the change from normal command bars to the Ribbon UI. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 14 Dec 2008 23:29:52 -0600, "Héctor Miguel" wrote: hi, Steven ! Is there a way to make a form open where the top left corner of the form will be the one cell to the right and one cell down from the active cell... all you need is Chip's Form Positioner http://www.cpearson.com/Excel/FormPosition.htm regards, hector. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do set/ fix the opening position of a user form | Excel Discussion (Misc queries) | |||
| Position Form on screen v Window Zoom ! | Excel Programming | |||
| freeze/lock form position | Excel Programming | |||
| How to position form in same place with different screen resolutions | Excel Programming | |||
| Form start position | Excel Programming | |||
Threaded Mode
