How to make on worksheet "sticky"

[Kalts]

Hello all,
I have a excel file with many worksheets and I've made one worksheet to be a list of contents to navigate between worksheets. Is there a way how I can make this worksheet "come along". If I click on hyperlink it goes onto that page it supposed to go, but to choose another worksheet I have to go back to the end to find list of contents worksheet. It would be great if it would automaticalli change its position and places itself next to selected worksheet.
Is this possible?

[Bob Phillips]

Assuming the sheet is called Master, add this code to the ThisWorkbook code module

Please Login or Register  to view this content.

[Kalts]

Thank you Bob, it kind of works, but it keeps me on the list of content sheet. I want it to just come next to selected sheet, but not keep me always on list of contents sheet.

[Kyle123]

It sounds like you need a userform. This will stay open regardless of sheet

[Bob Phillips]

I don't understand you, it is using the activate event, which means another sheet is activated.

[Kalts]

but it keeps me on list of contents sheet. if I click on another sheet, its only viewable until mouse button is hold. as soon as I release it, I get list of contents sheet.

---------- Post added at 02:19 PM ---------- Previous post was at 11:28 AM ----------

is there any way to correct it?

[Bob Phillips]

Post your workbook, so we can see what you mean.

[Kalts]

I got it working with the code I got from mr.excel forum

Please Login or Register  to view this content.

[Cutter]

@ Kalts

Good to see that you that you found a solution to your problem, and thanks for sharing it, but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

[Kalts]

sorry for that.