I have a question pertaining to a function with an add-in I'm trying to create.
It's a simple macro that when a commandbar button is clicked with activate it:
My problem is that I normally tie this to the selection change event so that it will continously clear formats and then allow the crosshair to move. Since I'm not applying it to a specific worksheet, is there a way to plant the selection change event in the function or another way to get the event to fire?
It's a simple macro that when a commandbar button is clicked with activate it:
My problem is that I normally tie this to the selection change event so that it will continously clear formats and then allow the crosshair to move. Since I'm not applying it to a specific worksheet, is there a way to plant the selection change event in the function or another way to get the event to fire?
