Hello people,
1- Copy following code into Sheet1 module.
2- See MessageBox When you click Sheet1.![]()
Private Sub Worksheet_Activate() MsgBox "Hello" End Sub
3- Copy following code into ThisWorkbook module.
4-See MessageBox When you click any of sheets.![]()
Private Sub Workbook_SheetActivate(ByVal Sh As Object) MsgBox "Hello" End Sub
Question: How to change above code to work only Sheet1 clicking?
Bookmarks