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.
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.