Is there a RibbonX attribute that I can set on a tab that will minimize the tab?

I have a USysRibbons file in Access 2007 that removes all default ribbon tabs and displays my one custom tab, but I want to ensure that my custom tab is minimized by default. Is there an attribute that I can set on my custom table to minize it?
RiverWalkAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
hnasrConnect With a Mentor Commented:
I tried the function in a module and the code works.

SendKeys issues a key sequence for the open window.
See the efect by setting a break point after the call MinimizeRibbon statement, and the effect will be opening the help system.
0
 
RiverWalkAuthor Commented:
I found this code to minimize the ribbon.

if Application.CommandBars.Item(“Ribbon”).Height > 100 then
        SendKeys “^{F1}”, True
end if

I mainly want to minimize the Ribbon on startup only, so this might work for me, but I have ready several references from people saying that they do not like to use Send Keys. Can you please tell me why people might not like using Send Keys? Are there some problems inherent with using Send Keys?

Thank you,
RiverWalk
0
 
RiverWalkAuthor Commented:
Actually, once I implimented the above code, it did not work. No error messages, but it is not working.

I placed it in a function, like so....

Function MinimizeRibbon()
  If Application.CommandBars.Item("Ribbon").Height >= 100 Then
    SendKeys "^{F1}", False
  End If
End Function

And called it in the Form Open event, like this....

Call MinimizeRibbon

But nothing happens and the Ribbon is not minimized.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.