Need help with VBA code to protect individual worksheets with different password (for different user) in one excel file.
For instance the file has Sheet1, Sheet2, Sheet3. I would like to protect Sheet2 with Password2, and protect Sheet3 with Password3. Sheet1 can be shown to all users.
Also need to force user to enable macro whenever they open the file.
Thanks :-)