How to Unlock Excel Sheets Fast with VBA

[@launchexcel]

*Watch more videos* 1. Top 30 Excel Tips and Tricks kzbin.info/www/bejne/nqC4n42Mh9qfgsUsi=IuhVulBwgP_R27-q 2. List all your sheets efficiently in Excel (VBA) kzbin.info/www/bejne/iaqqfYqlnJpsfaM 3. Highlight Active Row & Column in Excel (VBA) kzbin.info/www/bejne/aJO6gJV8ecR2e6s *Click here for the article with full VBA code:* www.launchexcel.com/unlock-excel-workbook-and-worksheets-vba *Download the Free Excel Workbook* Step 1: Sign up for free: go.launchexcel.com/email-signup-youtube Step 2: Log in here: courses.launchexcel.com/dashboard/en/login Step 3: Download: courses.launchexcel.com/school/course/workbook-downloads/lecture/5074882#headline-e1935e9b *TIP: Stay logged in for quick access to all FREE workbook downloads.*

[@leaovulcao]

I enjoyed and learned your first 2,videos on the power of VBA workbooks. Now I must practice, practice until I get it. You’re truly a Master of teaching and your voice and poise makes learning more enjoyable. You are blessed. Thank you so much!

[@martintayler23]

Very good explanation of the methods used to "hack" passwords in a project. You can do this manually of course, however the VBA is so much more efficient and you have set it out beautifully. Thank you Victor.

[@launchexcel]

Thank you, Martin! I’m glad you found the explanation clear and the VBA helpful. I appreciate your feedback.

[@jaironaranjo3654]

Thank you for such great presentation!

[@kebincui]

Excellent video. Thanks for sharing 👍

[@launchexcel]

Thanks for your comment!

[@hansakaerandaranasinghe6455]

i will try this

[@AlessioGianfrate]

Hi, Very interesting videos Can this method also remove the password on the macro code?

[@launchexcel]

There's a VBA solution here but I can't speak to its effectiveness: stackoverflow.com/questions/1026483/is-there-a-way-to-crack-the-password-on-an-excel-vba-project It claims to work for VBA password protection. But probably not if the VBA Project is protected with special obfuscation (such as Unviewable+ from Spreadsheet1 spreadsheet1.com/unviewable-vba-project-app-for-excel.html#/) Hope that helps!

[@scotolivera8207]

very informative

[@launchexcel]

Thank you!

[@user12345654]

Didn't know that VBA could be used to remove protection from excel workbooks also. 👍👍

[@cremadepruta6074]

awesome

[@launchexcel]

Thank you

[@Dexter101x]

I didn't realise how powerful VBA in Excel was

[@launchexcel]

VBA has definitely got a lot of power, and most Excel users have no idea it exists. Stay tuned for more 😀

[@abhishekawari919]

I have an another problem can we use vba for this and create something automatic in this task- Having 2 data file in excel format expenses and invoice data from this 2 file we have copy certain data and paste into the invoice generator file fileds and create a pdf copy invoice wise and store in the desired folder and rename as as per required format ?

[@launchexcel]

Yes VBA can automate all of this. And more 😊. Creating PDF invoices from Excel files in a specific folder is a good project for VBA.

[@cycu87]

What about XLS formats? Can they also be unlocked using this method?

[@launchexcel]

Sadly it doesn't work for XLS files because they don't use the XML format.

[@cycu87]

​@@launchexcel Is there any way to decrypt the password in files with the xls extension?

[@redhaakhund1271]

🙏⭐️⭐️⭐️⭐️⭐️

[@launchexcel]

😊thanks

[@dluhut83]

What if the Workbook itself is protected? In a sense, a user needs to input password before it opens up/show the contents? How to remove it?

[@launchexcel]

The file open password, which blocks access to the entire Excel workbook until the correct password is entered, is the most difficult to bypass. Unfortunately, the VBA code in this video cannot remove this type of protection. As far as I know, the only way to unlock a workbook with a file open password is through a brute-force method, which involves trying every possible character combination until the correct password is found. There are websites that offer this service, but I don’t have any specific recommendations.

[@ThinkCode-]

Please dont make more videos on vba, vba has been finished

[@launchexcel]

Thank you for your comment. In my opinion, VBA is still very relevant to Excel users. I know Office Scripts and Python are moving in, but there's still a lot that VBA can do that's useful and powerful. VBA is a powerful tool that many people could use to improve their workflows. I'm interested to hear what would you recommend instead of VBA?

[@OdelLeal]

Also many companies don’t upgrade. And we need to work with these tools. Can you imagine I am working nowadays with excel 2016? This is my reality 😂

[@launchexcel]

​@@OdelLeal I hear you! Not everyone gets to use the latest shiny tools, and VBA is often the unsung hero that keeps things running in older versions like Excel 2016. I guess we’re all “time travelers” when we’re working with legacy systems. At least VBA still gets the job done-even if it feels like we’re typing on stone tablets sometimes! 😂

[@OdelLeal]

@@launchexcelyes. You are right.