Activate worksheet with custom view?

[Ironman]

Hi

I have a custom view named "All Routes List"

I'm trying to activate this view when the worksheet named "Analysis" is opened.

I've tried inserting the below code in the worksheet:

Private Sub Worksheet_Activate()
CustomViews("All Routes List").Show
End Sub

And it returns "Compile error - Sub or function not defined"

Please can you help?

Thank you.

 

[Ironman]

Brilliant, you did it Michael! I hadn't inserted the underscores between words in the Custom View List.

Many thanks!

 

[Michael M]

Glad it worked ......finally...

 

[My Aswer Is This]

Interesting. I had never used Custom View before.

This could come in handy for things.

 

[Michael M]

Handy if you have a set of data set up for special reasons, then hide the whole set.....the code will unhide the set as required !!!