Need Excel sheets to share a macro
Posted on 2001-08-07
Many sheets in my workbook have their own copy of the same macro. To reduce space, I'd like there to be only one copy that they all can share. The macro begins:
"Private Sub Worksheet_Change(ByVal Target As Range)"
It goes into action if there is input in certain cells.
Can it be modified and put in a common area where it will be accessible to all sheets?