All spec sheet metal
Sometimes, though, you want to password-protect and unprotect all worksheets in a workbook in one step because protecting and unprotecting each worksheet individually is a huge nuisance. Here is how you can simplify this task. If you want to make changes to a protected worksheet, it is possible to use the Protect method on a protected worksheet if the password is supplied. Also, another method would be to unprotect the worksheet, make the necessary changes, and then protect the worksheet again. Oct 06, 2014 · 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 to do specially when you have a power of doing it using VBA. Jun 28, 2010 · A question came in recently regarding whether you can password protect just the VBA code for an Access database, but not the rest of the database. The answer is yes! Next time you go to view the VBA code, youâ€™ll be prompted for the password. Note that there are a lot of free or inexpensive ... If you want to run a macro on a protected worksheet, and keep the code visible and editable in the VB editor ie. not to protect the VBA project in the code window with a password; and further you do not want to disclose or display the password (used for worksheet protection) to the user, use the following method.