Exactly what I have been looking for: how to universalize your macros by PERSONAL Macro Workbook AND by adding special TABS with macros to the ribbon. So hard to find it, really. Great stuff, Sumit. Very clear explanation. No jibberish. No wavering. Clear cut and with immediate examples. THANKS A MILLION!
Good explaination bro i have see more then 5 video but not be able to understand becz they explain round and round your teaching was straight forward keep doing it. Thank you so much
I have also been looking for a simple thing: share your code between worksbooks and there is so much unrelated stuff it took a me a bit to find this very helpfull video. Thx
Sumitji, I always appreciate the style of your explanation which is really makes complex topics easy to understand. We would also request you to upload a tutorial on creating Add-ins in excel that can be used in all workbooks.
Excellent Video. You have the knack of explanation with ease and perfection. Sumitji, can you also guide me as to how you created those hyperlinks in excel from web. I am very much interesred to know that. Thanks and God Bless.
thanx for such awesome content. could you plz do a tutorial on how to remove all selected rows hyoerlinks at a single click. no problem if vba required.
Thank you so much, this is very helpful! I did run into a problem though, part of the codes only run on my first workbook, why is that? has something to do with the "ThisWorkbook" in the coding? thanks.
Thank you, Sumit for your videos!! Is there a way to include an unmerging of all cells in a macro without having to select all? I want to build a macro that includes this function, but the selecting of the cells seems to freak out the macro.
Hi there, your way of searching new vba stuff is gr8. I really wanna know as per you, what could be z of vba from a to z. Please respond if you feel this question worth
Awesome 👏 So clear and concise. I have saved macros but cannot delete and now I know how. Also can you show me how to amend the macro? I have very simple one that does a format of filter, comma on the number and I want to extend the Range as some days I have more data and macro does not run properly.
mi only question, if I do remove the PERSONAL.XLSB i am basically removing the macros right? that is my only doubt. Understanding that basically I will know who to share my macros with other for instance.
Hi sumit I do have one interesting question on If text join could you please help me out ...Refer to the IF statement excel workbook. Given people’s name on one line, their street address on the next line, and their city, state and zip code on the following line. How could you put each person’s information in on one line where you join the text the alternatives rows must be blank , once drag the row downwards it gives the join context without affecting the blank rows in between
Hi Sumit, Your videos are excellent . Especially VBA Course. Just want to ask you How can I delete the modules etc from VBA project if I want to start afresh. Thanks.
From the VBA page, right click on the Module you want to delete and select “Remove Module”. Msg pop up will ask you whether you want to take backup of the module or not. You can select yes or no as per your preference.
One more question... I have to run about a 100 CSV files per month. And format it eg: delimited, comma, text, date and so on. Can I set this up on a macro to do it for me?
I have created a macro in my personal workbook but when I saved it(macro enabled) in a shared path my teammates are unable to run the macro and there is no VBA found in their system. Please help me to fix this
Some of my macros have been deleted from my Personal Macro workbook. Any reason this might happen? Should I create a different module for every macro I create or can I put them within the same module (within my Personal Macro workbook)? Thanks
Hi Sir, i have macro to change the comment shape, it is working fine if i run it applies for the particular sheet, assume it had 300 rows of content and has many cells has comment in it, after i ran the macro it applies to all of them it is fine, later to that if i use insert comment it is coming the default one, then if i run the macro again, it is getting apply from first and taking time, is there any way it need to apply only for the recent one, so it save time
I want to create a macro but the location of the file keeps changing as per the date. Can I make a macro in which the location can be used as per name date as the folder name is the date
Hi I want to make table of contents for my many worksheets in an excel file. And want a back button or link in every worksheets for go back to table of contents sheet. How can I do it? Without VBA if possible?
A good way would be to create an add-in that has the code. It's a really simple process. You can then share the add in with everyone, and whoever installs it would also have access to the code
Exactly what I have been looking for: how to universalize your macros by PERSONAL Macro Workbook AND by adding special TABS with macros to the ribbon. So hard to find it, really.
Great stuff, Sumit. Very clear explanation. No jibberish. No wavering. Clear cut and with immediate examples. THANKS A MILLION!
Same 😊
I finally figured out how to delete multiple personal workbook & learned so many tips ! Thank you!!!!
Love this guy.
Straight to the point.
He makes for a very good mentor. I'm surprised at the few likes, versus the views.
Thank you! This video helped me setup and save my first macro. This single act will save me a few minutes each day. Can't wait to learn more.
Your videos are truly clear cut & straight. What I actually want to know, I've always found in your channel. Thanks a lot man.
Good explaination bro i have see more then 5 video but not be able to understand becz they explain round and round your teaching was straight forward keep doing it. Thank you so much
Very useful and clear instructions, albeit fast for my taste. Yes, I know I can slow it down via the youtube playback speed!
Thank you again.
Wow. This was one of the best video about Excel macro workbook. You included every details in clear and concise manner. Subscribed....
straight, easy to follow , complete
thank you man
Very helpful, clear and concise. The best tutorial I've found on this topic... thank you!
👍Your videos are truly clear cut & straight. What I actually want to know.
Thank you so much Sumit, exactly looking for this, thanking once again
I have also been looking for a simple thing: share your code between worksbooks and there is so much unrelated stuff it took a me a bit to find this very helpfull video. Thx
This is brilliant. Thank you so much for sharing your knowledge
Great job Brother.Keep it Up.
Thanks for sharing, I just wanted to know how do i share my created macros with others, so they can use in their computer ?
Sumitji, I always appreciate the style of your explanation which is really makes complex topics easy to understand. We would also request you to upload a tutorial on creating Add-ins in excel that can be used in all workbooks.
Awesome Sumit..👏
Thanx a lot, this is what i was searching !!!
Very Important and useful Video.... thanks
Best content so far
That was very helpful. Thank you.
Thank you this helped me a lot!
Very useful Tips.You are simply great! 👍
Dear Sumit ji, you are always precise and lucidly powerful, thanks a lot sir
Really I found those video very useful.
You're absolutely the best. I love you man 👍💜
loved your video !
Awesome! That's great! You help me a lot! 😁
Thanks sir for this valuable information..
Excellent video👍. Thank you.
This is something 👍 awesome
You are a genius!
Excellent Video. You have the knack of explanation with ease and perfection. Sumitji, can you also guide me as to how you created those hyperlinks in excel from web. I am very much interesred to know that. Thanks and God Bless.
Amazing, thank you.
You have some amazing videos, thank you! Quick question, how would you make the personal.xlsb work on workbooks stored in a server?
Amazing tips! Thanks a lot...
Very useful!!
thanx for such awesome content. could you plz do a tutorial on how to remove all selected rows hyoerlinks at a single click. no problem if vba required.
Awesome 👍
Thank you so much 😊
Brilliant
Thank you so much, this is very helpful! I did run into a problem though, part of the codes only run on my first workbook, why is that? has something to do with the "ThisWorkbook" in the coding? thanks.
Thank you, Sumit for your videos!! Is there a way to include an unmerging of all cells in a macro without having to select all? I want to build a macro that includes this function, but the selecting of the cells seems to freak out the macro.
Love it!
it helps a lot...
Thank you.
Good bro🤜🤜
you saved me today
Thank you
This is amazing video ... i have a question on these files extension ... should it be as .xlsm ?
If you save a macro on Personal Macro workbook, you can use it on any workbook. Doesn't need to be an xlsm file
Hi there, your way of searching new vba stuff is gr8.
I really wanna know as per you, what could be z of vba from a to z.
Please respond if you feel this question worth
Greate video, Sumit. Is there any way to customize and use my personal macros in excel 2007?
Awesome 👏 So clear and concise. I have saved macros but cannot delete and now I know how. Also can you show me how to amend the macro? I have very simple one that does a format of filter, comma on the number and I want to extend the Range as some days I have more data and macro does not run properly.
Thanks a lot sir
you saved me a lot of time waste
mi only question, if I do remove the PERSONAL.XLSB i am basically removing the macros right? that is my only doubt.
Understanding that basically I will know who to share my macros with other for instance.
Hi sumit I do have one interesting question on If text join could you please help me out ...Refer to the IF statement excel workbook. Given people’s name on one line, their street address on the
next line, and their city, state and zip code on the following line. How could you put each person’s
information in on one line where you join the text the alternatives rows must be blank , once drag the row downwards it gives the join context without affecting the blank rows in between
Hi Sumit, Your videos are excellent . Especially VBA Course. Just want to ask you How can I delete the modules etc from VBA project if I want to start afresh. Thanks.
From the VBA page, right click on the Module you want to delete and select “Remove Module”. Msg pop up will ask you whether you want to take backup of the module or not. You can select yes or no as per your preference.
Thanks sir,How can I customize a picture of the macro from the net
One more question... I have to run about a 100 CSV files per month. And format it eg: delimited, comma, text, date and so on. Can I set this up on a macro to do it for me?
I have created a macro in my personal workbook but when I saved it(macro enabled) in a shared path my teammates are unable to run the macro and there is no VBA found in their system. Please help me to fix this
Some of my macros have been deleted from my Personal Macro workbook. Any reason this might happen? Should I create a different module for every macro I create or can I put them within the same module (within my Personal Macro workbook)?
Thanks
Excellent tutorial but with the command
? Application.StartUpPath
I get my path but when I go to the Windows the folder is empty!!
sir whenever i closed my laptop new day i open excel a blank open but the heading is personal workbook.what i will do. thanks
Hi Sir, i have macro to change the comment shape, it is working fine if i run it applies for the particular sheet, assume it had 300 rows of content and has many cells has comment in it, after i ran the macro it applies to all of them it is fine, later to that if i use insert comment it is coming the default one, then if i run the macro again, it is getting apply from first and taking time, is there any way it need to apply only for the recent one, so it save time
I used macros on a workbook but when I run it in another sheet in same workbook then it won’t work as it worked in sheet 1 .. what could be the issue
Can I add function (vba)to it? I fail to add
I want to create a macro but the location of the file keeps changing as per the date. Can I make a macro in which the location can be used as per name date as the folder name is the date
Hi
I want to make table of contents for my many worksheets in an excel file. And want a back button or link in every worksheets for go back to table of contents sheet. How can I do it? Without VBA if possible?
In short, you wanna make index for your work with backend link attached to every cell?
@good ..How to deploy this personal macro workbook to all users in a company??
A good way would be to create an add-in that has the code. It's a really simple process. You can then share the add in with everyone, and whoever installs it would also have access to the code
@@trumpexcel can you makea video on how to do this
In some spreadsheets I get a warning that the xlsb is in use? You guys get this? I can still acess
th-cam.com/video/Oifbewu1v90/w-d-xo.html
I will test this:
i am getting error i am unable to record personal macro workbook
I have created a function, but I can't use it in other workbook
👍
I am getting hide error, Any faced this issue.
i found error when i use my Macro file in other PC
How to delete macros from all workbooks
👍👍👍👍👍👌
Duuuuuuuuude.
Bro मुझे हिंदी मांगता है।
Thank you so much sir
Even though I save it But it is not showing saved file in macro
😮