Héctor,
Thank you for the response. I tried the download file and it gives me an
error in this section at the : VCmdArr(.RowIndex) = .Height ; it says
subscript out of range for the VCmdArr(.RowIndex). What is causing this?
For Each CmdBar In Application.CommandBars
With CmdBar
If (.Visible = True) And (.Position = msoBarTop) Or (.Position =
msoBarMenuBar) Then
If .RowIndex 0 Then
VCmdArr(.RowIndex) = .Height
End If
End If
If (.Visible = True) And (.Position = msoBarLeft) Then
If .RowIndex 0 Then
HCmdArr(.RowIndex) = .Width
End If
End If
End With
Next CmdBar
Thank you,
Steven
"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.