Run another macro from within this macro
Hi Cathy,
To find the original code just search 'clock hands' on this site,
there are only a few entry's.
Also l can confirm that the cell usually needs to be edited directly
to trigger the macro.
An alternative is to use a spin button from the 'control toolbox' and
trigger the macro using the 'spinbutton_change' event. (This is
similar to using the sheet code module but in this case right click
the spin button and click view code.)
Reagrds
Michael
|