Navigation spreadsheet - how to not list hidden sheets

[kawa13]

Hi guys,

I use Excel as a navigation tool. The code automatically creates hyperlinks in column "A" of the "Index" sheet.

Unfortunately, it also creates hyperlinks to a sheet/ sheets that I'd like to keep hidden. I know, it's devious of me LOL, but I want to prevent users from tampering with some elements of the sheet and also I'm just a bit curious as to how this could be done anyway

Any ideas on how to do this?

Regards,

Kawa13

[:) Sixthsense :)]

Replace this line

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

[JosephP]

one line needs to be changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[kawa13]

Stunning mate. Works a treat

Many thanks

Kawa13