No video :(

Personal Macro Workbook - Reuse Macros in Any Workbook in Excel

Подписаться 376 тыс.

Просмотров 65 тыс.

50% 1

In this video, I will show you how you can reuse macros in any workbook by saving these in the Personal Macro Workbook.
A Personal Macro Workbook is an Excel file (Personal.XLSB) that is created and saved in the XLSTART folder. This file opens whenever you start Excel.
So if you save any macro or custom function in this Personal Macro Workbook, it will make those macros available to all your Excel Workbooks.
In this video, I will show you how to create a Personal Macro Workbook and how to copy macros in it.
00:00 Intro
00:20 Creating a Personal Macro Workbook
03:00 Copy Pasting Macro Code in Personal Macro Workbook
04:55 Adding Macro to Quick Access Toolbar
06:05 Adding a New Tab in the Ribbon for Macros
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com...
✅ Free Dashboard Course - bit.ly/free-ex...
✅ Free VBA course - bit.ly/excel-v...
✅ Free Power Query Course - bit.ly/power-q...
✅ Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #ExcelTips #ExcelTutorial

Опубликовано:

17 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 87

@strangerintheselands251 2 года назад

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!

@bhaveshkurhade9568 8 месяцев назад

Same 😊

@meganzhang9448 2 года назад

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

@harshvardhan3711 17 дней назад

Thank you so much sir

@yaxbhagdev5540 6 месяцев назад

Thank you so much 😊

@jimwille1541 2 года назад

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.

@shrs.3448 2 года назад

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.

@mahargleopenaws 2 года назад

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

@NilayMukhopadhyay 3 года назад

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

@arunssairam 2 года назад

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

@sajjadabouei6721 6 месяцев назад

straight, easy to follow , complete thank you man

@familystreamer8799 Год назад

you saved me today

@ladyferioli 3 года назад

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

@shane45220914 Год назад

Thank you.

@christinehowell 2 года назад

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

@hksongcollection2549 2 года назад

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

@LhotseMS 7 месяцев назад

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

@jeevanmarg Год назад

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

@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 ?

@deluxelex9056 Год назад

Brilliant

@mustafanoyon8086 7 месяцев назад

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

@kanemac1443 2 месяца назад

That was very helpful. Thank you.

@amitkuril96 2 года назад

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

@lauracarlin1595 Год назад

Thank you this helped me a lot!

@junaopako 3 года назад

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

@MrDhunpagla 3 года назад

This is something 👍 awesome

@lahotipushkar 3 года назад

Very useful Tips.You are simply great! 👍

@harshadsg 3 года назад

Very Important and useful Video.... thanks

@oscargo29 3 года назад

Excellent video👍. Thank you.

@SophieThwaites-zi9pq 3 месяца назад

Amazing, thank you.

@rajeevgosavi4514 2 года назад

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.

@MasudRana-oy5fk Год назад

Really I found those video very useful.

@TheHaamleet 3 года назад

You are a genius!

@biditkumarsarbajna1817 2 года назад

Best content so far

@sanumpzha 2 года назад

Awesome Sumit..👏

@hemantgoyal409 3 года назад

Thanks sir for this valuable information..

@vaidehimodi2083 10 месяцев назад

loved your video !

@juliandavidtoromedina1315 Год назад

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

@vipuljhaveri4805 3 года назад

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

@k4karthi 3 года назад

Amazing tips! Thanks a lot...

@RohitKumar-cc7zi 2 года назад

Good bro🤜🤜

@Aparna_777 3 года назад

Very useful!!

@rish545 2 года назад

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.

@rajeevgosavi4514 2 года назад

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.

@kashif8650 3 года назад

Awesome 👍

@mohdimranyusof2889 2 года назад

it helps a lot...

@zynkers401 2 года назад

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

@realpulsecoin 3 года назад

Love it!

@owenlau2025 8 месяцев назад

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.

@dishantmunjal7793 Год назад

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

@apriltwenty4945 3 года назад

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.

@morganstanley1475 3 года назад

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

@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.

@genetresom2380 2 года назад

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

@santiagosantiveriarenas4250 18 дней назад

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.

@HusseinKorish 3 года назад

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

@trumpexcel 3 года назад

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

@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

@TindSarkar 3 месяца назад

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

@shunkitchui2289 Месяц назад

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

@KiranKumari-vs6by 5 месяцев назад

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

@khalidmajeed2886 2 года назад

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

@jayantketkar8711 3 года назад

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 2 года назад

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.

@muhanadmawasalkazmeh137 3 года назад

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

@gagansingh3481 2 года назад

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

@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

@chinnabalu7820 2 месяца назад

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

@apriltwenty4945 3 года назад

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?

@IvanCortinas_ES 3 года назад

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

@hariharagupta5638 3 года назад

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

@bappy2453 Год назад

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

@rabikantverma9770 2 года назад

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

@Joy-jp3pm 10 месяцев назад

I am getting hide error, Any faced this issue.

@realpulsecoin 3 года назад

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

@realpulsecoin 3 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Oifbewu1v90.html

@realpulsecoin 3 года назад

I will test this:

@nazeery1816 3 года назад

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

@trumpexcel 3 года назад

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 2 года назад

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

@yesjii6072 2 года назад

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

@Garimaish 3 года назад

👍

@prashantrawat6738 3 года назад

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 3 года назад

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