I am trying to create a simple navigation in 20 worksheets with different names, just like in this forum:
But I want mine to say:
Please Login or Register to view this content.
And I want to be able to click the links to get to the start page and to reload the current active worksheet.Please Login or Register to view this content.
Any suggestions on how I can accomplish this?
Can you upload sample of your workbook with the expected output?
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
This type of thing navigation menu??
I am still trying to achieve this effect. Any suggestions?
I want cell B2 to say:
orPlease Login or Register to view this content.
Please Login or Register to view this content.
Where Hyperlink is a hyperlink that you can click and go to the home page, reports in a hyperlink that you can click and go to the reports page etc.
Anyone?
I want Home, Reports and May to be clickable as an URL!Please Login or Register to view this content.
I have tried using hyperlink without results!
Can anyone give me some suggestions on how I can accomplish this?
It sounds like you are trying to create a situation where clicking on different parts of a string will bring you to different places in a workbook.
Where is the string that you would click on?
In your example "start / active worksheet name", what is "start"? a workbook?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi, thank you for your reply!!
I am trying with any string. I want to be able to click "Home", "Reports" and "May". When I click "Home" I get to my startpage, when I click "Reports" I get to my reportpage etc.
="Home" & " > " & " Reports" & " > " & "May"
At the moment I am doing this manually but I would like to use activesheet for it to be automatic.
So the string is not a structure of different levels (like the navigation on this website) but a history of your "travels".
Where do you want this string?
Thank you for your reply!
I would like it to be like a structure of the different levels (just like the navigation on this webpage).
Anywhere, say cell E6.
But I am curious of the latter example, like a history of my travels.
Could you teach me how to do both?
For Excel, there are three levels, Workbook, Worksheet and Range
A level based string would look like Book1 > Home > $A$1
And when the user went to the report sheet the string would look like Book1 > Report > $A$1
In post #9, the string Home > Report > May is a history of what sheets you traveled to (all on the same level)
Thank you for your reply, you are correct and I didn't think about the three levels in Excel!
I want the string Home > Report > May.
The attached sheet has a user-defined heirachy
Home
-Report
--Jan
--Feb
--Mar
-Sales
--January
--February
---ValentinesSales
--March
The sub SetHeirarchy allows you to specify which sheet is the immediate superior. It should be run everytime you make a new worksheet. Note that the top level sheet (Home) has no superior.
Navigating between the sheets will create a (temporary) floating command bar that you can click on to navigate to the indicated sheet.
Please Login or Register to view this content.I hope this helps.Please Login or Register to view this content.
Hi, thank you for your reply! I have tried your attached workbook and copy & paste to a new document and I don't see any floating command bars :/
SetHeirarchy works and I have tried running it from a shape also. Where is the floating bar supposed to be?
Last edited by waimea; 12-02-2018 at 03:32 PM.
If you open my workbook and switch between sheets, does the command bar appear?
Hi, no. The SetHeirarchy marco runs but I don't see any command bars! I am using Excel 2016.
Try changing this part of the code (in Module 1).
Then save the file, QUIT excel (don't just close the workbook) and the open the workbook again.
Please Login or Register to view this content.
I have tried your suggestion but I still don't see any commandbars!
Does it work for you in your attached workbook?
Yes, it works for me (Excel 2011)
Ok, I don't have access to Excel 2011!
Could you help me with an easier way to get my desired string?
I have tried hyperlink but I don't understand how to create X number of links in one string.
Please Login or Register to view this content.
Getting the string is one thing, but it has to be put in a place where clicking on it (or a portion of it) will take you to the desired sheet.
Hi, thank you for your replies!
Could you show me how to create a string with 3 different links in it?
Hi mikerickson,
could you show me how to create the navigation?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks