The useform startup position doesn't seem to take into account of the ribbon.
I couldn't find a way to test if the ribbon was minimized or not.
Tried to position relative to first row, but this still considers the ribbon, same position results if ribbon is minimized or not.
I couldn't find a way to test if the ribbon was minimized or not.
Tried to position relative to first row, but this still considers the ribbon, same position results if ribbon is minimized or not.
VBA Code:
Private Sub UserForm_Initialize()
Me.StartUpPosition = 0
Me.Top = Cells(1, 1).Top + 0 * Cells(1, 1).Height + 2 * Me.Height
End Sub