I’m a newbie to Access and VB, but have learned a lot from this forum. Thank you.
From what I’ve been able to piece together from the posts here is that the code below should hide the ribbon and navigation pane. Where am I making my mistake?
Any help is greatly appreciated.
Sub HideRibbon()
Dim i As Integer
For i = 1 To CommandBars.Count
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.Minimize
Next i
End Sub
Deb