<div>
Hi Wayne - &nbsp;I am not able to &quot;wake up&quot; the code. I place it in Module1, and click on sheets with no effect. Must be doing something wrong...<br />
<br />
Private Sub Workbook_SheetSelectionCha<wbr />nge(ByVal Sh As Object, ByVal Target As Range)<br />
MsgBox ActiveSheet.Name<br />
End Sub<br />
<br />
tks, V
</div>


Hi Wayne -  I am not able to "wake up" the code. I place it in Module1, and click on sheets with no effect. Must be doing something wrong...

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
MsgBox ActiveSheet.Name
End Sub

tks, V

<div>
Read Wayne's post again. <br />
<br />
&gt;&gt;&nbsp;The code for this would go in the <b>ThisWorkbook </b>module.<br />

</div>


Read Wayne's post again.

>> The code for this would go in the ThisWorkbook module.


<div>
Hi Teylyn - thank you for your comment<br />
cheers, v
</div>


Hi Teylyn - thank you for your comment
cheers, v

<div>
<div class="content wysiwyg-content">
Hello Experts - Is it possible to control any sheet in workbook off one module with code <br />
Worksheet_SelectionChange(<wbr />ByVal Target As Excel.Range)? As somebody here advised me earlier, rather than copying same macro to each sheet I could use this avenue instead. <br />
For example, I want to do this when click on any cell in sheet1 through Sheet20 &nbsp;...<br />
Worksheet_SelectionChange(<wbr />ByVal Target As Excel.Range)<br />
msgbox activecell.value<br />
<br />
Cheers, V
</div>
</div>


Hello Experts - Is it possible to control any sheet in workbook off one module with code 
Worksheet_SelectionChange(ByVal Target As Excel.Range)? As somebody here advised me earlier, rather than copying same macro to each sheet I could use this avenue instead. 
For example, I want to do this when click on any cell in sheet1 through Sheet20  ...
Worksheet_SelectionChange(ByVal Target As Excel.Range)
msgbox activecell.value

Cheers, V

Worksheet_SelectionChange

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.