|
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.
|