Options when workbook opens

Hello Again!

I would really like to know if there is a way that when my workbook opens if the following can happen?

- Not display the tabs (NOT "HIDE" the sheets, just not be able to view the tabs themselves)
- Go to full screen (not display ribbon)


Thanks!

hello.

please try.

Sub HideRibbon()

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

ActiveWindow.DisplayWorkbookTabs = False

End Sub

Sub ShowRibbon()

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

ActiveWindow.DisplayWorkbookTabs = True

End Sub

Edit
you will also need this in the THISWORKBOOK code section.

Private Sub Workbook_Activate()
HideRibbon
End Sub

Private Sub Workbook_Open()
HideRibbon
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ShowRibbon
End Sub

Private Sub Workbook_Deactivate()
ShowRibbon
End Sub

hope this helps

Hi rbyrd023
the first part

Private Sub Workbook_BeforeClose(Cancel As Boolean)
   ActiveWindow.DisplayWorkbookTabs = True
End Sub
Private Sub Workbook_Open()
 ActiveWindow.DisplayWorkbookTabs = False
End Sub

but why dont you want thr ribbon desplayed?

ok i dont know why the unload of the userform is triggring any of the procudures above,
you could use me.hide. or enableeventss = false befor the unload and enableevents= true after the unload.

it could be becouse the focus is going elsewhere and comming back to this workbook in a strange way, try the enableevents 1st.

if neither work can you post a workbook.
cheers.