L
ljb
I have written an add-in with a function that needs to be triggered by a
Worksheet_Change event. Can I put the event code in the add-in and have it
available to new worksheets? If not how do I call a function in the add-in
from my new worksheet? I've tried
Private Sub Worksheet_Change(ByVal Target As Range)
GetColors Target
End Sub
but Excel doesn't seem to know where to find GetColors.
thanks
LJB
Worksheet_Change event. Can I put the event code in the add-in and have it
available to new worksheets? If not how do I call a function in the add-in
from my new worksheet? I've tried
Private Sub Worksheet_Change(ByVal Target As Range)
GetColors Target
End Sub
but Excel doesn't seem to know where to find GetColors.
thanks
LJB