Hi --
I'm trying to run 2 codes that run on a specific sheet.
Each one runs on their own, but whenever I to have both of them, i get an error.
(Code below)
Any help?
Thanks!
Option Explicit
Private Sub worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$J$7" Then
If UserForm_ManualRevAdj.Visible = False Then
UserForm_ManualRevAdj.Show
End If
End If
End Sub
------
Private Sub worksheet_SelectionChange(ByVal Target As Excel.Range)
'Prevents Users from changing sheet names
If ActiveSheet.Name <> "Project Pricing Summary" Then
ActiveSheet.Name = "Project Pricing Summary"
End If
End Sub
Bookmarks