Excel-VBA : Range – Lock/Unlock Specific Cells
There are two different cases you might deal with, Lock only few specific cells and rest of the cells in the work sheet are not locked(means you can edit them) Lock the Enitre worksheet...
Category: Password Protected Macro
Excel-VBA : Change Passwords for all the WorkSheets in one shot
Objective : Suppose you have many worksheets in an excel and you want to change all the passwords in one shot rather doing it manually for every sheet, which might be very bad way...
Password Protection to Your Macro Code
In earlier sessions we saw that how we can write code, generate code and customize it but at the same time it’s very essential to protect it. Excel provides an option to make our...