Calling sub from CommandButton knowing which sheet is active
Hi G,
'-------------------
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.
'-------------------
Rather than inserting a new CommandButton on 50+
sheets, why not insert a new button on a toolbar and
assign the required the requred macro to the toolbar
button. In this way, you could use the ActiveSheet
property to identify the sheet.
---
Regards,
Norman
|