krrishkrsna
Board Regular
- Joined
- Jan 31, 2009
- Messages
- 84
Hi
unable to execute events between worksheets
in Sheet1 worksheet event
private sub Worksheet_Activate()
Msgbox "Hi"
End Sub
in sheet2 worksheet event
private sub Worksheet_Activate()
Application.Run "Sheet1.Worksheet_Activate"
End Sub
after googling used friend or public in place of private but no result. plz help
unable to execute events between worksheets
in Sheet1 worksheet event
private sub Worksheet_Activate()
Msgbox "Hi"
End Sub
in sheet2 worksheet event
private sub Worksheet_Activate()
Application.Run "Sheet1.Worksheet_Activate"
End Sub
after googling used friend or public in place of private but no result. plz help