Macros

Hi Susie,

Thank you for the forum question.

The macro below will protect all sheets in the workbook the code is executed in with the password myPassword. If you want another password change the password in the code.



Sub ProtectSheetsWithPassword()

'Protect worksheet with a password

For i=1 to Sheets.count
Sheets(i).Protect Password:="myPassword"
Next i

End Sub



The link below is to a website, where you can find a lot of vba protection options

https://exceloffthegrid.com/vba-code-worksheet-protection/

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector