Excel Formatting

[ozstephan]

Hi everyone:
I am using an excel document with multiple sheets which is also a shared document. I have set it up with one sheet being a menu with hyperlinks.

What I am trying to work out is if anyone knows how I can set the document up so when anyone opens it, it always opens to the sheet that has the menu (ie sheet 1) rather than opening to whatever page the document was last saved on?

Thanks everyone

 

[joelnichols]

Do all sheets have autofilter? If not, that causes that error to occur. I regret that I don't know how to check each sheet for autofilter, so you can either put a filter in each sheet or see if someone else can find a way around that. I'm not really very good with VBA

Happy Holidays.

 

[joelnichols]

An alternate solution, if every sheet does not have a filter, would be to select each sheet with a filter in it and unfilter.

Private Sub Workbook_Open() 
Sheets("sheet1").Select
    Selection.AutoFilter Field:=1 'this unfilters column 1
    Selection.AutoFilter Field:=2 'this unfilters column 2 etc..etc


Sheets("sheet2").Select
    Selection.AutoFilter Field:=1
    Selection.AutoFilter Field:=2
end sub

 

[ozstephan]

Joel:
Thanks so much for your help. The last option with the individual sheet workings was fantastic and allowed me to do everything I was hoping for.

Thanks again.
Stephan