Thread: activate marco command
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
macgru macgru is offline
external usenet poster
  
Posts: 20
Default activate marco command

Użytkownik "Dominic Mak" <Dominic napisał w
wiadomości ...
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.


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

mcg


Reply With QuoteReply With Quote