VBA code in excel to work for many sheets
Closed
issa
-
2 Feb 2012 à 13:17
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 - 2 Feb 2012 à 15:27
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 - 2 Feb 2012 à 15:27
Related:
- VBA code in excel to work for many sheets
- Excel vba find - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Sheets vba - Guide
- How to copy data from one excel sheet to another - Guide
- How to open vba in excel - Guide
1 response
aquarelle
Posts
7181
Registration date
Saturday 7 April 2007
Status
Moderator
Last seen
14 February 2026
491
2 Feb 2012 à 15:27
2 Feb 2012 à 15:27
Hi,
I think it is not necessary to write your code for each worksheet and I think that you should just try to write your code in "ThisWorkbook" like this :
Regards
I think it is not necessary to write your code for each worksheet and I think that you should just try to write your code in "ThisWorkbook" like this :
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Const PW As String = "issa2011"
Dim cRow As Integer
If Intersect(Target, Range("AQ12:AQ47")) Is Nothing Then Exit Sub
If Target.Value = "DTIME" Or Target.Value = "DTOME" Then
ActiveSheet.Unprotect PW
cRow = Target.Row
Range(Cells(cRow, "AR"), Cells(cRow, "AS")).Locked = True
ActiveSheet.Protect PW
Else
If Target.Value = "DTIME" And Target.Value <> "" Then
MsgBox "Please Note: there no need to fill time and thank you.", vbExclamation, Title:="Human Resource Office Warning"
End If
End If
If Target.Value <> "DTIME" Or Target.Value <> "DTOME" Then
ActiveSheet.Unprotect PW
cRow = Target.Row
Range(Cells(cRow, "AR"), Cells(cRow, "AS")).Locked = False
ActiveSheet.Protect PW
End If
End Sub
Regards