Calling sub from CommandButton knowing which sheet is active
Thanks Norman that worked.
How can I access that SUB from each of the 50 sheets I already have
made before I implemented this new code?
I tried copying the Command button to another sheet but it left the
code blank.
I also tried putting it in the Macro list to call it from each sheet
but the "Me" gave me and error also.
I remember vaugly that I if I select multiple sheets I can somehow
loop thru them all.
|