Hello:
I have a fundamental question... upon opening a DB, I *always* want to hide the RIBBON. I have added 2 lines of code where the 1st line, apparently, does not hide the ribbon (thus, it is currently commented out). Alternatively, the 2nd line appears to be working; however, the hiding/displaying of the ribbon alternates each time when I open the DB.
Code:
Private Sub Form_Load()
'DoCmd.ShowToolbar "Ribbon", acToolbarNo
CommandBars.ExecuteMso "MinimizeRibbon"
End Sub
That is, ...
1. Open DB for the first time... the ribbon is hidden.
2. Open DB for the second time... ribbon is displayed.
3. Open DB for the third time... the ribbon is hidden again.
etc. etc.
What code should be added/modified so that I always hide the ribbon and/or toolbar (unless I open the DB using the by-pass key)?
Thank you,
Tom
P.S. And, oh by the way, I only want the hiding of the ribbon/toolbar be applied to this particular DB... not every time I open up any other ACCDB file. That is, I just noticed that the hiding of the ribbon (this sample file) also hides the ribbon on a completely different DB. I don't want that!