How to Remove Macros from an Excel File (2 Easy Ways)
Вставка
- Опубліковано 9 вер 2020
- In this video, I'll show you how to remove macros from an Excel file.
You can choose to remove all the macros from an Excel workbook, or you can choose specific macros to delete from the workbook.
The following topics are covered in this video:
(00:17) Remove macros by saving the file in XLSX format
(02:18) Remove macros Using the Macro Dialog box
(03:35) Deleting the Module
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ua-cam.com/users/trumpexc...
#Excel #ExcelTips #ExcelTutorial
THANK YOU!!!!! you saved my work!
Awesome! Thank you so much for your content!
I have completed your 150 videos series on Excel tips & tricks and also looking to complete your other playlist. It is very helpful for me and I salute your method of teaching. Thanks, Sumit.
Thank you so much for creating very useful videos...👍🙏
Thank you!
Sir you are a great teacher I am learning excel because of your free course
Life saver!!!
Super explanation Sir 👌
Good one 👍
THANK YOU! SHIVA BLESS!
helpful
I have a growing list of smaller macros in my personal.xlsb file, so they can be used whenever and whereever they are useful (also in *.xlsx and *.csv files). General macros like clearing doubles, special formatting, special searching, etc etc. But there's no reason for these ones to fill up the macro list if I only use them once a month. So to remove these from the macro list but still keep them for the day I need them I just comment its entire code in the module, from Sub to End Sub. The macro disappears from the macro list but will still be quickly available the day I need it. Just uncomment the block and it's back in service again. Saves time.
Hi Sumit, thank you very much for the informative videos, I learned a lot through them, please let me know if I can contact you for more advise regarding my projects, thanks
In VBA project window, microsoft exel object and sheet names are not visible. Can't able to run macros. Any solutions
Can u do video on doing macro which can extract data from SAP?
Is there any way to remove a module using another macro just before i execute a saveas using a macro... my macrosheet has 10modules and i want to delete 9of them before my macro perform a saveas...
Sumit sir please make a video for python specially dataframe
Hi, Thanx for this video but it is not what I am looking for : a macro which I can delete an other macro into a worksheet. Do you know a code please ?
You got the like at
How about keeping the macro procedure but REM it so that it can be used whenever required.