VBA to list worksheet names apart from

[nicic]

Hi there,
I'm hoping someone can help. I'm creating a 'quick look' page, and need the worksheetnames in the first column to appear automatically, and change as sheets are added etc.
There will be 2-3 sheets I don't want listed.

I've played around with some vba code, I have a nice one from here to create a menu of all the sheets, which is hyperlinked. But my brain is struggling today, and I can't fathom how to list the worksheet names without a hyperlink, and in the cell I want (B3).

So basically, how can I autpoulate cells with worksheet names, that change dynamically, and stop it listing a set 3 sheets (names will be static). Oh and preferably sort a-z?

Thanks

 

[nicic]

That code does turn them into hyperlinks, which you originally said you didn't want

Sorry I've confused matters. The original post was regards a list without hyperlinks, I need that for something else.
But now I'm wondering if it would be better the use that for for the menu rather than the vba code?

Ideally I would like a menu of all the sheets, that can be filtered by a drop down list via product type. Say 'soap', lipbalm etc

I've done another thread asking about that.

 

[Fluff]

The original post was regards a list without hyperlinks, I need that for something else.

That is what this thread is about.

 

[Dave Patton]

Fluff "no need to use Lambda, you can just use this in the name manager"

Thanks for the information. Dave