excel+courses - Macros

Hi Peter

Try using this peice of VBA in a new module of the VBA editor.
It will set the password to 123, which you can change by simply editing the code below.

You can add your own macro buttons to your excel toolbar, and assign each macro.

I have also attached the example sheet so you can see it in action.

Regards

Richard

------------
Option Explicit
Sub Protectsheets()
Dim wsheet As Worksheet

For Each wsheet In ActiveWorkbook.Worksheets
wsheet.Protect password:="123"

Next wsheet

End Sub


Sub unprotectsheet()
Dim wsheet As Worksheet
Dim password As String
password = InputBox("Please enter the password")

For Each wsheet In ActiveWorkbook.Worksheets
wsheet.Unprotect password:=password

-------