Hello, All.

I am hoping to find a VBA solution for this and avoid custom UI modifications. But please keep in mind I am very new to VBA, but am trying to learn as much as possible.

I am trying to hide the ribbon, but leave the Formula bar, the tabs bar and the file menu.

I only need the file menu because some people that will be using this workbook (or most) do not know how to cntrl+s and often use the "Save and Send" function. Is this possible? I am currently using the below code to do everything other than allow the File menu.

Private Sub Workbook_Activate()

   Application.ScreenUpdating = False
   Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
   Application.DisplayFormulaBar = True
   Application.DisplayStatusBar = Not Application.DisplayStatusBar
   ActiveWindow.DisplayWorkbookTabs = True
   Application.ScreenUpdating = True

End Sub
Thanks in advance!