Personal Macro Workbook - Reuse Macros in Any Workbook in Excel

[@strangerintheselands251]

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!

[@bhavesh_kurhade]

Same 😊

[@meganzhang9448]

I finally figured out how to delete multiple personal workbook & learned so many tips ! Thank you!!!!

[@mahargleopenaws]

Love this guy. Straight to the point. He makes for a very good mentor. I'm surprised at the few likes, versus the views.

[@jimwille1541]

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.

[@NilayMukhopadhyay]

Your videos are truly clear cut & straight. What I actually want to know, I've always found in your channel. Thanks a lot man.

[@RysioM-re3ed]

A very good and quick guide , thank you

[@jeevanmarg]

Wow. This was one of the best video about Excel macro workbook. You included every details in clear and concise manner. Subscribed....

[@hksongcollection2549]

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

[@mustafanoyon8086]

👍Your videos are truly clear cut & straight. What I actually want to know.

[@shrs.3448]

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.

[@christinehowell]

Very helpful, clear and concise. The best tutorial I've found on this topic... thank you!

[@sajjadabouei6721]

straight, easy to follow , complete thank you man

[@LhotseMS]

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

[@arunssairam]

Thank you so much Sumit, exactly looking for this, thanking once again

[@ladyferioli]

This is brilliant. Thank you so much for sharing your knowledge

[@mdmahedihasan6666]

Great job Brother.Keep it Up.

[@TheSarveshdubey]

Thanks for sharing, I just wanted to know how do i share my created macros with others, so they can use in their computer ?

[@amitkuril96]

Thanx a lot, this is what i was searching !!!

[@rajeevgosavi4514]

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.

[@junaopako]

You're absolutely the best. I love you man 👍💜

[@sanumpzha]

Awesome Sumit..👏

[@biditkumarsarbajna1817]

Best content so far

[@lahotipushkar]

Very useful Tips.You are simply great! 👍

[@vipuljhaveri4805]

Dear Sumit ji, you are always precise and lucidly powerful, thanks a lot sir

[@lauracarlin1595]

Thank you this helped me a lot!

[@MasudRana-oy5fk]

Really I found those video very useful.

[@kanemac1443]

That was very helpful. Thank you.

[@abcxyz-123-c8l]

Very Important and useful Video.... thanks

[@juandavidmunoz2781]

Thank you!!

[@juliandavidtoromedina1315]

Awesome! That's great! You help me a lot! 😁

[@vaidehimodi2083]

loved your video !

[@oscargo29]

Excellent video👍. Thank you.

[@hemantgoyal409]

Thanks sir for this valuable information..

[@TheHaamleet]

You are a genius!

[@MrDhunpagla]

This is something 👍 awesome

[@k4karthi]

Amazing tips! Thanks a lot...

[@SophieThwaites-zi9pq]

Amazing, thank you.

[@owenlau2025]

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.

[@deluxelex9056]

Brilliant

[@Aparna_777]

Very useful!!

[@yaxbhagdev5540]

Thank you so much 😊

[@RohitKumar-cc7zi]

Good bro🤜🤜

[@mohdimranyusof2889]

it helps a lot...

[@kashif8650]

Awesome 👍

[@shane45220914]

Thank you.

[@familystreamer8799]

you saved me today

[@rish545]

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.

[@michellekellis5893]

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.

[@magmaar1896]

Thank you

[@zynkers401]

You have some amazing videos, thank you! Quick question, how would you make the personal.xlsb work on workbooks stored in a server?

[@realpulsecoin]

Love it!

[@rajeevgosavi4514]

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.

[@genetresom2380]

Greate video, Sumit. Is there any way to customize and use my personal macros in excel 2007?

[@santiagosantiveriarenas4250]

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.

[@dishantmunjal7793]

Thanks a lot sir you saved me a lot of time waste

[@HusseinKorish]

This is amazing video ... i have a question on these files extension ... should it be as .xlsm ?

[@trumpexcel]

If you save a macro on Personal Macro workbook, you can use it on any workbook. Doesn't need to be an xlsm file

[@muhanadmawasalkazmeh137]

Thanks sir,How can I customize a picture of the macro from the net

[@TindSarkar]

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

[@hariharagupta5638]

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

[@shunkitchui2289]

Can I add function (vba)to it? I fail to add

[@gagansingh3481]

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

[@KiranKumari-vs6by]

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

[@apriltwenty4945]

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?

[@khalidmajeed2886]

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

[@ashwinisg7012]

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

[@morganstanley1475]

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

[@Gav-qz8ey]

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

[@apriltwenty4945]

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.

[@nazeery1816]

@good ..How to deploy this personal macro workbook to all users in a company??

[@trumpexcel]

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

[@negrito2100]

@@trumpexcel can you makea video on how to do this

[@jayantketkar8711]

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.

[@adityasharma0101]

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.

[@realpulsecoin]

In some spreadsheets I get a warning that the xlsb is in use? You guys get this? I can still acess

[@realpulsecoin]

kzbin.info/www/bejne/hZrJk5itqpapb5I

[@realpulsecoin]

I will test this:

[@prashantrawat6738]

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?

[@morganstanley1475]

In short, you wanna make index for your work with backend link attached to every cell?

[@rabikantverma9770]

i am getting error i am unable to record personal macro workbook

[@bappy2453]

I have created a function, but I can't use it in other workbook

[@IvanCortinas_ES]

Excellent tutorial but with the command ? Application.StartUpPath I get my path but when I go to the Windows the folder is empty!!

[@yesjii6072]

i found error when i use my Macro file in other PC

[@Joy-jp3pm]

I am getting hide error, Any faced this issue.

[@TK123..]

How to delete macros from all workbooks

[@rathore422]

👍👍👍👍👍👌

[@Garimaish]

👍

[@chubbydawme]

Duuuuuuuuude.

[@ChiwraKailash]

Bro मुझे हिंदी मांगता है।

[@harshvardhan3711]

Thank you so much sir

[@chinnabalu7820]

Even though I save it But it is not showing saved file in macro 😮