Hi Folks,
A few days ago Luke was kind enough to help me with a bit of code which worked a treat.
It was to except a sheet from being protected. I need to add another sheet, called "Data" to the exception rule.
I Tried to adapt the code Luke sent me but failed miserably
(
Here is the code for which I need the further exemption.
[pre]
[/pre]
Also, I wonder if its possible to have a data entry form "pop-up" when a sheet is selected (more VBA I suspect).
Hope this is making sense.
A few days ago Luke was kind enough to help me with a bit of code which worked a treat.
It was to except a sheet from being protected. I need to add another sheet, called "Data" to the exception rule.
I Tried to adapt the code Luke sent me but failed miserably
Here is the code for which I need the further exemption.
[pre]
Code:
Private Sub workbook_open()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> "Monthly Sorted" Then
With ws
.Protect Password:="les", UserInterfaceOnly:=True
.EnableOutlining = True
End With
End If
Next ws
End Sub
Also, I wonder if its possible to have a data entry form "pop-up" when a sheet is selected (more VBA I suspect).
Hope this is making sense.