*Watch more videos* 1. Top 30 Excel Tips and Tricks ruclips.net/video/hoUnZVRulLc/видео.htmlsi=IuhVulBwgP_R27-q 2. List all your sheets efficiently in Excel (VBA) ruclips.net/video/SyGLWog59GA/видео.html 3. Highlight Active Row & Column in Excel (VBA) ruclips.net/video/2bWObFD_CEI/видео.html *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.*
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!
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.
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!
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 ?
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.
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 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! 😂
*Watch more videos*
1. Top 30 Excel Tips and Tricks ruclips.net/video/hoUnZVRulLc/видео.htmlsi=IuhVulBwgP_R27-q
2. List all your sheets efficiently in Excel (VBA) ruclips.net/video/SyGLWog59GA/видео.html
3. Highlight Active Row & Column in Excel (VBA) ruclips.net/video/2bWObFD_CEI/видео.html
*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.*
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!
Thank you for such great presentation!
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.
Thank you, Martin! I’m glad you found the explanation clear and the VBA helpful. I appreciate your feedback.
Hi,
Very interesting videos
Can this method also remove the password on the macro code?
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!
Excellent video. Thanks for sharing 👍
Thanks for your comment!
Didn't know that VBA could be used to remove protection from excel workbooks also. 👍👍
i will try this
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 ?
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.
very informative
Thank you!
I didn't realise how powerful VBA in Excel was
VBA has definitely got a lot of power, and most Excel users have no idea it exists. Stay tuned for more 😀
awesome
Thank you
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?
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.
🙏⭐️⭐️⭐️⭐️⭐️
😊thanks
Please dont make more videos on vba, vba has been finished
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?
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 😂
@@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! 😂
@@launchexcelyes. You are right.