Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Run macro when excel workbook gains focus

On further observation, the OnTime method (I guess like all Methods)
does not remain, pending return focus to Excel if another application
is executed between start and scheduled time.

OnTime talks about waiting on a function completing and then the OnTime
function/macro running. This would appear only to be correct if Excel
remains the active application and has not been "deactiviated", to say,
check Outlook in the mean time.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate monthly gains/losses in excel ragingriver30 New Users to Excel 2 May 23rd 10 01:51 PM
making gains or losses appear red or black in formula Blane Excel Worksheet Functions 1 April 5th 06 02:06 AM
gains/losses formulas kgeorge Excel Worksheet Functions 3 March 24th 06 09:25 PM
Excel macro takes focus from other programs RUL Excel Programming 3 August 9th 05 01:56 PM
Template for IRS form capital gains/losses R2005SC Excel Discussion (Misc queries) 0 January 17th 05 06:51 PM


All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"