VBA Basics: How To Protect Your Hard Work With Excel VBA

[@ExcelForFreelancers]

😱 𝗨𝗡𝗕𝗘𝗟𝗜𝗘𝗩𝗔𝗕𝗟𝗘 𝟲𝟱% 𝗢𝗙𝗙 𝗧𝗛𝗜𝗦 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬! 👉 www.excelforfreelancers.com/BFSale2024_YTPinnedComm

[@FunnyGeyser-zw1uc]

Great refresher video. Learn something new always.thanks

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@SyedMuzammilMahasanShahi]

Thank you so much Randy for this amazing video.

[@ExcelForFreelancers]

For sure, you are very welcome Syed and I am happy to help and share

[@temyraverdana6421]

Another great lesson. Thanks a lot

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Temyra. Thanks for your continued support

[@ranilan00]

So important! What would we do without you?

[@ExcelForFreelancers]

Thank you and I am so happy you found this valuable along with your continued support.

[@Michael--Hubbard]

Thank you Randy, I cannot get it to work on my program to save my life. Too many conflicts with other macros. I currently have a password with application undo to save changes, I would love to get it figured out someday.

[@ExcelForFreelancers]

Hi Michael. thanks for your comment. I am sure we can help. Can you post your detailed issue and screenshot in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

[@keitamoussa2229]

Ohhhhh come on Randy how can you just read a person's mind from such a distance? :) After watching your Store management system I am currently working on a similar project and after finishing it I want to sell it to some local point of sales. I was thinking about how to secure that application and you're making this tutorial now. What else can I say but thank you for your never-ending groundbreaking tutorials. Remember you are changing lives.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Keita. Your years of support is never forgotten

[@taimoorkhan8203]

happened with me as well... the very moment when I needed something and Randy cameup with the tutorial video...

[@ExcelForFreelancers]

@taimoorkhan8203 I am very happy I could help. Thank you for your Likes, Shares & Comments. It really helps.

[@RonDavidowicz]

Great video. I never knew about the userinterface, option. This is a game changer! I’m an intermediate vba coder and I always use unprotect/protect code around what I want vba to do. Will this option allow vba to refresh pivot tables without first unprotecting?

[@ExcelForFreelancers]

Hi and thanks Ron. Yes certainly, VBA can make the necessary changes, including Pivot Table refresh, while the document is protected. Please remember to re-protect the file on open. I hope this helps and thanks so much.

[@vsartesuo]

The subject matter of the training was excellent. If you know anything about password protection for office applications, you will know that the password protections presented in your training can be bypassed in less than 2 minutes and your documents will be completely unprotected. I'm interested in real protection that actually works so that the hard work you do is actually protected. Would it be possible to learn about protection options that actually work and protect in training courses? Although the feedback is direct I generally really like the content of your channel.

[@ExcelForFreelancers]

Hi and thanks so much. Anything can be hacked, however, that should never stop us from developing applications, because 99.9% of people do not want to break into our software. The issue is that people worry so much about protection, they don't develop applications. I have made hundreds of thousands of dollars developing applications that can be cracked by anyone. So let them crack it if they want, and I will just keep developing applications. I hope this helps and thanks so much.

[@vsartesuo]

@@ExcelForFreelancers It's absolutely true that if you're afraid of everything, you don't make progress. It was just a fair warning to those who didn't know. Personally, I always try to make my own decisions based on the facts and that's why I brought it up. However, the intention was not to prevent or slow down software development in any way. Keep up the good work and you have a very good attitude for feedback!

[@ExcelForFreelancers]

That is so great to hear, and thanks so much for your reply. Well said :)

[@davidcunha7377]

Hey There Randy thank you so much for another Valuable VBA lesson. Any chance you could do a part 2 where the Excel Workbook is linked to the Hardware code of the users computer. This way our work wont be distributed to multiple unauthorized computers. Thank You

[@ExcelForFreelancers]

Hi and thanks very much. I do share that with you here: kzbin.info/www/bejne/ol7XmKyHq8l2a8k and perhaps here: kzbin.info/www/bejne/hImxcmWrrqisgNE I hope this helps and thanks so much.

[@abdullahsafi9430]

Awesome work, thank you very much we really needed that! But how can we protect the shapes from being deleted by the user when they still work as buttons?

[@ExcelForFreelancers]

Hi and thanks so much. The shapes still are clickable, even if they are protected, so there is no issue there. I hope this helps and thanks so much.

[@henkvinck888]

Top Training THNX Randy

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@vilmorevilladolid527]

hi randy, great training as always 👏is there a sample or link for the VBA component protection in the last option for the cheatsheet? thanks in advance!

[@ExcelForFreelancers]

HI and thanks for your comment. I have reviewed this and it's only possible by protecting the VBA Project as a whole. It's a bit misleading and I apologize for that. I have removed this last item from the cheat sheet moving forward. Thank you for your Likes, Shares & Comments. It really helps.

[@vilmorevilladolid527]

@@ExcelForFreelancers thanks Randy :-) more power!

[@DDrummond]

Will allowformating: = false allow a user to paste values only from their clipboard?

[@ExcelForFreelancers]

Hi and thanks for your comment. Yes this is correct. I hope this helps and thanks so much.

[@youssefkheireddine3012]

can i allow delete and insert columns with copied formulas in a protected sheet

[@ExcelForFreelancers]

Hi and thanks very much for your comment. You can allow that through the protection settings and formulas will adjust accordingly, however any VBA code would need to be updated. I hope this helps and thanks so much.

[@joseroque8753]

wow very interesting!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and I am sure you will love this training

[@analyticneuron2797]

Hi! I found your videos recently and I am learning excel. May I know which excel version do you use? I cannot see the developers tab on it :'. Am i missing something? Appreciate your response!

[@ExcelForFreelancers]

Hi and thanks so much. I am using Excel 365. If you don't see the Developers tab, you can right click any menu item and then go to Customize and select the Developers tab. I also go over this in my Excel VBA for beginners series here: kzbin.info/aero/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.

[@rsiddique1584]

Sir if you are make a video in hindi ane english mixture language i hope that your growth in youtube will so high

[@ExcelForFreelancers]

Hi and thanks so much. Each of my videos have Hindi subtitles. I hope this helps and thanks so much.

[@ahmedmoha5764]

😍😍😍😍😍😍

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@МуратНургазин]

Hi, Randy. I watched this video on protecting VBA Excel code. I set a password. But my colleague easily cracked it and changed the code. How can I protect VBA in the best possible way so that no one can crack it?

[@ExcelForFreelancers]

Hi and thanks for your comment. You can use a stronger password or perhaps a 3rd party protection tool such as xlspadlock bit.ly/SecureExcel I hope this helps and thanks so much.

[@ranilan00]

👏👏👏👏

[@ExcelForFreelancers]

Thank you so very much, I really appreciate all of your continued support

[@ramamuruthyrevoori8255]

Randy sir please no need third party apps for protection expecting any open source or other use full information waiting,.........

[@ExcelForFreelancers]

HI and thanks very much. There are some 3rd party apps such as XLS Padlock: bit.ly/SecureExcel However I have never used, or needed, a 3rd party app for protection. I hope this helps and thanks so much.

[@billgyrotech]

Off topic but has anyone else requested a prepper pantry?

[@ExcelForFreelancers]

Hi and thanks so much. I have written this idea down already and if i get enough requests I will certainly consider creating a training on this in the future. I hope this helps and thanks so much.

[@drojanprojectchannel]

This is cool. Cant wait. Avid follower here

[@ExcelForFreelancers]

Thanks so much. I am sure you are going to love it

[@drojanprojectchannel]

@@ExcelForFreelancers you did not fail me. thank you so much for this valuable lesson. I glad I subscribed.

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help

[@not1AM]

there are tools and apps that break all these protections. so technically all these methods are not that secure

[@ExcelForFreelancers]

Of course nothing is completely secure. But we should not care about making something perfectly secure. If people want to steal our work, they will. We will just focus on making great applications, giving a ton of value and making a lot of money. If we fear about theft, we will never build anything. Thank you for your Likes, Shares & Comments. It really helps.

[@chrisk.9765]

There is no way to protect excel and VBA project which can't be cracked...

[@slminc]

Why worry about the tools be cracked? Microsoft knows that people crack most of its applications, they don’t producing their software. Most of the applications created here are customized. So cracking them should not stop people from creating them.

[@ExcelForFreelancers]

Hi and thanks so much. Anything can be hacked, however, that should never stop us from developing applications, because 99.9% of the people do not want to break into our software. I hope this helps and thanks so much.

[@jinuchoe343]

The answer is unviewable program!!!