Greetings,
Yes vbaInet, it pains me greatly to have stooped to putting one SendKeys call in my application... ( http://www.access-programmers.co.uk/forums/showthread.php?t=218500#post1114474 )
Is there a non SendKeys way to minimize the Ribbon? In my Internet searching, using SendKeys is all I have been able to turn up.
It would be handy if there were a NavigateTo constant similar to the one ( http://www.access-programmers.co.uk/forums/showthread.php?p=1127715&posted=1#post1127713 ) which is for the Navigation Pane. Is there one for the A2007 Ribbon?
Yes vbaInet, it pains me greatly to have stooped to putting one SendKeys call in my application... ( http://www.access-programmers.co.uk/forums/showthread.php?t=218500#post1114474 )
Code:
'Make sure the Ribbon is minimized
If MePointer.Application.CommandBars.Item("Ribbon").Height > 80 Then
SendKeys "^{F1}", False
DoEvents
End If
It would be handy if there were a NavigateTo constant similar to the one ( http://www.access-programmers.co.uk/forums/showthread.php?p=1127715&posted=1#post1127713 ) which is for the Navigation Pane. Is there one for the A2007 Ribbon?
Last edited: