L
Liz C
I have the following macro I'm using in a workbook and would like to use it
in another workbook.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Rows(Target.Row).Interior.ColorIndex = 17
Columns(Target.Column).Interior.ColorIndex = 17
End Sub
Will someone please tell me how to copy it to use in the other workbook?
Thank you in advance for your help!
in another workbook.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Rows(Target.Row).Interior.ColorIndex = 17
Columns(Target.Column).Interior.ColorIndex = 17
End Sub
Will someone please tell me how to copy it to use in the other workbook?
Thank you in advance for your help!