Password Protection Multiple Workbooks & sheets

[VinodKrishnappa]

Hi,

I Need help in to protecting sheets in multiple workbooks in a particular folder.

With a particular password 1st i would like to protect sheets from editing in multiple work books in a folder. I also need to provide a different password to open that work book.

It's like with a password user has to open the work book but not to edit.

Can you provide some solutions for this.

Regards,
VK

 

[mumps]

Click this link to download your file: https://app.box.com/s/eo2chuob9ajtd4ell193oeejbog2y7p8
This file contains a macro in the code module for ThisWorkbook which opens the file in a minimized state and displays a userform asking for a password. The password is "MyPassword". If you enter the correct password, the window will be maximized and become visible. If you enter the wrong password, Excel will close. If you manually run the macro in Module1, it will loop through all the files in your folder and then all the sheets in each file, lock all the cells and protect the sheets so that they cannot be edited. The password used to protect the sheets is also "MyPassword". In this module, you will also need to change the folder path where indicated to suit your needs. You will have to use the Visual Basic Editor (ALT+F11) to change all occurrences of "MyPassword" in all the macros (code module for ThisWorkbook, Module1, code module for UserForm1) to a password of your choosing as well as change the folder path.