Change_Event macro dismiss table1 copy reinstate Table1
Hi Garry,
Actually I was going to keep the "task" part in a module, mostly because there was already a script there and was doing almost the same thing as I wanted in the event code. Just modify it a bit and that would have done the job. Then it seemed to be a bit of "over do" to call from each sheet, and there would be sheets from "A" to "Z".
I was thinking correctly, but went the other way.
Thanks for the tip.
Howard
|