View Single Post
 
Old 10-17-2014, 12:39 AM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default How to Control Worksheet Event Handler in Module?

Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub
For example, the above codes must be put under a sheet to be effective. Is it possible to make it effective under a module? Because I want to use the codes contained in a module every time for any other Excel files.

Any help is appreciated.
Reply With Quote