Hi there
I want to create an On Timer event in Excel like you would on an Access Form.. ie every 10 seconds, refresh the form, or change the colour of something.
I cannot find anything that would let me do this. I have written a macro to change the colour of some cells every ten seconds, but whilst that macro is running, you cannot access any of the toolbars, and if you double click in a cell it stops the macro etc etc etc...
can anyone help me?
Jo
)
I want to create an On Timer event in Excel like you would on an Access Form.. ie every 10 seconds, refresh the form, or change the colour of something.
I cannot find anything that would let me do this. I have written a macro to change the colour of some cells every ten seconds, but whilst that macro is running, you cannot access any of the toolbars, and if you double click in a cell it stops the macro etc etc etc...
can anyone help me?
Jo
)