Good day to all,
I have an issue that I hope someone here can help me resolve it. I looked at other similar threads but none seem to solve my issue. The difference between other threads and my problem is that I am using a "Symbol" for all my hyperlinks to go to a specific hidden sheet. How do I define each symbol in a different cell to link to it's related hidden sheet? Please see attached image to understand the issue better.
TYIAMenu Page.JPG
A simple macro will accomplish this... not sure about hyperlinking. I've never looked into that.
right-click the image (little orange triangles) and assign it a macro:
Edit: I see they are not images but characters... you could draw in little clear boxes behind the triangles and assign a macro to that instead. There are ways to click on a cell and perform an action but I think a shape is easier.
Please Login or Register to view this content.
Last edited by carlmon; 05-12-2022 at 03:35 PM.
Hi Carlmon
Ok, I just saw your full code. I will give it a try and let you know.
Thank you
Sounds good. If you like this approach, I'll write you a code that hides the cell when selecting the main tab.
P.S I've worked in an aerospace nut/bolt manufacturing plant... I hope you like your job more than I liked mine! lol
I think I will go with your code. I could import the triangle as an image and use your code that way. I'll appreciate if you also give me the code to hide the sheet.
Thank you very much for your help
I know exactly what you mean. Where I work, those who assigned part numbers to each part did a terrible job. It is a nightmare to organize them properlyHTML Code:
Yeah, my place had over 800 employees & ran 24/7, 7 days a week, 365 --- things got chaotic..Originally Posted by Adsk2007
Give this code(below) a go; just make sure you put it on the Main sheet code found in the project explorer or by right-clicking the tab at the bottom. I didn't debug it, but I will.
Please Login or Register to view this content.
Thank you, I will give it a try as soon as I get home and let you know by tomorrow.
Best Regards
Your code works like a charm. One small error i found in your second code. You didn't end the IF statement. Below is what I changed it to and It worked fine.
Thank you for all your help
Please Login or Register to view this content.
Hi there,
Here's an approach which allows you to keep sheetnames out of your code, and uses only a single common routine for all of the sheet selection buttons in the workbook.
The destination sheetnames are entered in the cells immediately to the left of the sheet selection buttons. The same process is used for the "Return To Menu" button on each of the worksheets. The columns which contain the sheet names (C for the Menu worksheet and A for each of the other worksheets) may be hidden if required.
The attached workbook uses the following code:
Please Login or Register to view this content.
Hope this helps - please let me know how you get on.
Regards,
Greg M
Last edited by Greg M; 05-12-2022 at 04:53 PM. Reason: Workbook attached
Hi Greg
Thank you for helping with this issue. I will try the code and let you know
Regards
Greg,
Wow, that is also a great way of doing it.
Regards
@Greg
My code only references the sheet name of the MAIN sheet that he won't change... it doesn't matter what the rest of the sheets are called - they will be hidden...
Apologies, I see what his code does... looks good.
Thanks to you both for your feedback - glad you like it!
Regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks