activate marco command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear friends,

I have written many marco commands for an active worksheet with the learn
marco command using Visal Basic. The current time on my worksheet will be
updated automatically.

How can I write another marco command that could activate each of the marco
commands based on certain true condition. e.g. after the passage of every
minute.

Please help.
 
U¿ytkownik "Dominic Mak said:
Dear friends,

I have written many marco commands for an active worksheet with the learn
marco command using Visal Basic. The current time on my worksheet will be
updated automatically.

How can I write another marco command that could activate each of the marco
commands based on certain true condition. e.g. after the passage of every
minute.

Please help.
Click to expand...


if you want to run macro in a given period of time try to use
application.ontime + name of your macro

mcg
 
Back
Top