View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
 
Posts: 274
Default 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