3 Password Attempts to Open Excel file using VBA and macros

✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
In this tutorial we will assemble an Excel file that can only be used if we enter a password. In case of entering a password wrongly 3 times, the file will be closed. Also, if the file is opened with the macros disabled, then only one sheet will be displayed informing us that we must use it with the macros enabled.
First steps
Sheet1 will be the main sheet of the file and Sheet2 will be the sheet where instructions will be shown to use the file. The first thing we must do is block some elements so as not to use the file in case the macros are disabled:
In the Review tab we choose Protect book. We mark Structure and assign a password.
We enter the VBA IDE using the combination [Alt] + [F11].
We choose Sheet1 and in the properties window we choose the Visible property and choose the value xlSheetVeryHidden.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
Photo by Jon Moore on Unsplash