Hi All ..
Having a problem with protecting a sheet and then the VB Coding doing a flip.
I have set so that if a number is entered into Column B .. then it will auto populate the 'NOW' date into column C.
But when I protect my sheet .. it wont do it.
I have ticket 'Formate Cells' .. but still doesnt seem to work.
Any ideas?
Tayler
Re: Protecting Sheet with VBA Code
Can you post a sample of what you have to get a better understanding of what you are trying to acccomlish?
Re: Protecting Sheet with VBA Code
Here is what is set into the worksheet.
Now when I protect the sheet .. this doesnt work.
The DEBUG highlights in yellow the line ..
.Value = Now
Can this not be run if you have protected the sheet?
Tayler
Private Sub Worksheet_Change(ByVal Target As Range)
'
'Calculating Date & Time for File Allocation Column B to Column C
'
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("B5:B605"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yy"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End SubRe: Protecting Sheet with VBA Code
See: Run Macros On Protected Worksheets via the UserInterfaceOnly argument of the Protect method.
Re: Protecting Sheet with VBA Code
ActiveSheet.Protect Password:="Password", UserInterfaceOnly:=True
Works just ducky if you enter it towards the end of your code... it also allows for one to duplicate the sheet(s) without losing control over the protection.. I've tried all the rest and they work fine for static workbooks however, in the real world workbooks are more dynamic then that...
Good Luck
pirate:
Don’t have an account yet? Register yourself now and be a part of our community!