Hello all,
Yes, I'm new to this forum. I have to say, the info here is great and has gotten me over a few difficult moments. Now I have another hurdle I just can't overcome.

I am using the following code to hide the workbook ribbon and toobar so the end user only sees the worksheet and data entry fields. However, once the code is in place and working, I'm even blocked from breaking through and getting back to the development stage. Access has a Shift + open file override. Does Excel have something similar? Or saving two copies, one with the code and one without, my only option??

Thanks in advance!
Nathalie

Private Sub Workbook_Activate()

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

End Sub

Private Sub Workbook_Deactivate()

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

 End Sub