Oh yes, absolutely. Some of my larger templates such as the School Manager, Employee Manager or Ultimate ERP would be perfect with this. Thank you for your Likes, Shares & Comments. It really helps.
Sir it's my Humble request to you please make a vdo of variable and i have also seen that your vdo "Mastering variable" and i learned a lot by that vdo but their you explain normal variable but please also make a video on Worksheet Range object etc. like you write in this Video "Dim WkSht as Worksheet" i and my friend i not able to understand that why did you write this in code "Dim WkSht as Worksheet" it's my humble request to make seprate vdo on this topic so it is very Easy to relate with your codes i'm waiting for that Vdo. Thanks so much Have a good Day Sir.
Hi and thanks for your suggestion I have a video coming up on all types of objects coming next week including Application, Workbook, Worksheet, Range, Charts & Shapes. I hope this helps and thanks so much.
In order to return to the TOC menu do I need to create a separate button and micro on each page worksheet that I go to from the Table of Content page ?
Hi and thanks, you can create an icon such as a Home icon and then a macro such as Sub GoToHome() Sheet1.Activate End Sub You can then assign the macro to the button. You would just want to update your Sheet name. I hope this helps and thanks so much.
Hi and thanks Dan. Yes for sure you can use a list of hyperlinks. You can put a list of links in cells, create a named range for the list and then use that list in he data validation drop down list. I hope this helps and thanks so much.
You would want to create a macro, and that macro would be a change event on the drop down list of the cell. Assuming your drop down list is in Cell A1 Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A1")) Is Nothing And Range("A1").Value Empty Then ThisWorkbook.Sheets(Target.Value).Activate End If End Sub just make sure the drop down list contains the exact sheet names I hope this helps and thanks so much.
Hi and thanks, a macro can be assigned a shape and then inside the macro you can put Sub FollowLink() ThisWorkbook.FollowHyperlinks YourLink End Sub Something like that would work
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
Just what I was looking to learn Randy.
Keep up the good work 🙆🙆♂🙆♀
Great, thanks so much Raymond. I am happy to help and share
everyone watching this video please give a thumbs up for Randy
My opinion is : RANDY IS THE BEST
Thank you so very much, I really appreciate that
Would give two, if I could!! 👍👍
Thank you, Randy!
Yes he deserves all the likes and subscribe. He is doing a great job.
Thanks so much Nathaniel
Thanks Randy ... This is something I have in my Personal macro book. Very useful for easy navigation
Awesome Neren, Thank you so very much, I really appreciate that
Thank you Randy for this amazing video.
For sure, you are very welcome Syed, thanks for your continued support over the years
Again thank you very much RANDY for this intressant video, you are a genius
For sure, you are very welcome and thanks so much. I appreciate that.
great job Randy as usual
Thank you so very much, I really appreciate that
You're the God of Excel
Thank you so very much, I really appreciate that and I am very happy to help and share
This could be put into your other programs you have.
Oh yes, absolutely. Some of my larger templates such as the School Manager, Employee Manager or Ultimate ERP would be perfect with this. Thank you for your Likes, Shares & Comments. It really helps.
thank u ... + add ... because is a TOC :) u can ...after displaygridlines > ActiveWindow.DisplayHeadings = False
YEs for sure thank so much and a nice idea. Thank you for your Likes, Shares & Comments. It really helps.
Sir it's my Humble request to you please make a vdo of variable and i have also seen that your vdo "Mastering variable" and i learned a lot by that vdo but their you explain normal variable but please also make a video on Worksheet Range object etc. like you write in this Video "Dim WkSht as Worksheet" i and my friend i not able to understand that why did you write this in code "Dim WkSht as Worksheet" it's my humble request to make seprate vdo on this topic so it is very Easy to relate with your codes i'm waiting for that Vdo.
Thanks so much
Have a good Day Sir.
Hi and thanks for your suggestion I have a video coming up on all types of objects coming next week including Application, Workbook, Worksheet, Range, Charts & Shapes.
I hope this helps and thanks so much.
I have been waiting for this video... Is there a way we can include start and end page numbers in Toc of each worksheets
Yes and thanks so much, Page #'s can be added if you assign them to the sheet names or use the Sheet Index #
I hope this helps and thanks so much.
Randy, can we see a workbook that integrates VBA, Office Scripts, and Power Automate? Or either of the two with VBA would be greatly appreciated.
Very interesting and thanks for the idea. I will do my best to explore these ideas.
Waiting
Thank you so very much, I really appreciate that
In order to return to the TOC menu do I need to create a separate button and micro on each page worksheet that I go to from the Table of Content page ?
Hi and thanks, you can create an icon such as a Home icon and then a macro such as
Sub GoToHome()
Sheet1.Activate
End Sub
You can then assign the macro to the button. You would just want to update your Sheet name.
I hope this helps and thanks so much.
Excelente
Hi and thanks so much. Gracias Gerardo. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy.
Can you use a dropdown list for hyperlinks.
Hi and thanks Dan. Yes for sure you can use a list of hyperlinks. You can put a list of links in cells, create a named range for the list and then use that list in he data validation drop down list. I hope this helps and thanks so much.
@@ExcelForFreelancers
Ok thanks
Hi Randy.
I tried what you said but it doesn't work.
The drop-down list just shows the links but clicking on them does nothing.
You would want to create a macro, and that macro would be a change event on the drop down list of the cell. Assuming your drop down list is in Cell A1
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing And Range("A1").Value Empty Then
ThisWorkbook.Sheets(Target.Value).Activate
End If
End Sub
just make sure the drop down list contains the exact sheet names
I hope this helps and thanks so much.
@@ExcelForFreelancers
Thanks
Can a shape contain a hyperlink?
Hi and thanks, a macro can be assigned a shape and then inside the macro you can put
Sub FollowLink()
ThisWorkbook.FollowHyperlinks YourLink
End Sub
Something like that would work
Sir! How to save selected range as jpeg or png file?
Hi and thanks very much. I show you how to do that here: th-cam.com/video/1sZdHchyibo/w-d-xo.html
@@ExcelForFreelancers Thank you very much sir!