How to Password Protect a Workbook with Code after it is Saved

How to Password Protect a Workbook with Code after it is Saved?

Securing your workbooks with passwords is a crucial step in ensuring the safety of your data. However, what if you forgot to set a password before saving your workbook? Don't worry, you can still protect it by following these steps:

1. Open the saved workbook in Excel.
2. Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.
3. Insert a new module by clicking Insert > Module.
4. Copy and paste the following code:

Sub ProtectWorkbook()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Protect Password:="YourPassword"
Next ws
ThisWorkbook.Protect Structure:=True, Windows:=False, Password:="YourPassword"
End Sub

5. Replace 'YourPassword' with your desired password.
6. Run the code by clicking Run > Run Sub/UserForm or pressing F5.
7. Close the VBA editor and save your workbook.
8. Your workbook is now password protected!

Remember to keep your password secure and easy to remember but hard to guess for maximum protection.