Options when workbook opens

[rbyrd023]

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!

[D_Rennie]

hello.

please try.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

hope this helps

[pike]

Hi rbyrd023
the first part

Please Login or Register  to view this content.

but why dont you want thr ribbon desplayed?

[Alf]

Perhaps like this:

Sub Auto_open()
'
'
With ActiveWindow
.DisplayHeadings = False
.DisplayWorkbookTabs = False
End With
End Sub

HTH

Alf

[rbyrd023]

Thanks for all the help! To: D_Rennie ,Works great when opening but when a userform is closed using "Unload Me" it goes back to showing everything! Anyway to stop that or to close a userform with different verbage?

[D_Rennie]

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.

[rbyrd023]

OK very wierd! Only one userform makes it do that and I'm not to concerned about that one! Thank you for your help!