I have the following code in ThisWorkbook VBA Excel Objects of my file book1.xlsm
It works ok. It displays the ActiveSheet.Name everytime I change Selection.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Is it possible to make it work in other opened workbooks as well?
Also Is it possible to display the ActiveSheet.Name ONLY if I change WorkSheet and not every time I click on a different cell..
Thanks in advance