Protection

[RichardU]

How can you set a worksheet up to be protected when a user opens it but still allow a seperate macro to edit protected cells?

Like protect the sheet on open and unprotect before close?

Any other suggestions

 

[DiscoPistol]

If you only want certain people to be able to edit the workbook you could try .

Private Sub Workbook_Open()
a = Environ("username")
If a = "Permitted user" Then
Exit Sub
end if

'Protect Worksheet Here

End Sub

DP

 

[Richard Schollar]

Hi Richard

You could include within the macro code an unprotection ... and reprotection routine (and run macro code between the two ie whn the sheet is unprotected):

Sub mySub()
Activesheet.Unprotect "Password"
'do stuff...
'....
Activesheet.Protect "Password"
End Sub

You will then need to consider protecting your VBA project eg if you don't want users to see the protection password.

 

[RichardU]

Thanks thats a great help, and the password does not need to be hidden as it is just so that novice excel users dont ruin my formatting etc.

Also is it possible to allow certain locked cells to be tabed to even when they are locked?
i.e.

o = locked
o = unlocked
o = locked cells i want to tab to

o o o o o o

???