I'm writing a navigation simulator. The macro contantly updates the
simulated postion but needs to allow the user to update cells that contain
data such as heading and speed that the macro uses. I'd rather not require
the user to stop and restart the macro if possible since the calculations all
require elapsed time e.g. distance = rate * time.

"Jim Thomlinson" wrote:

You can't. Give us a little more info and we can probably help you to
accomplish what you want though...
--
HTH...

Jim Thomlinson


"Ev" wrote:

How can I run an Excel macro but let the user update the spreadsheet while
the macro is running?