Results 1 to 1 of 1

Macro to scroll through 3 workbooks on timer if no activity

Threaded View

  1. #1
    Registered User
    Join Date
    12-22-2011
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    58

    Macro to scroll through 3 workbooks on timer if no activity

    I am using excel 2010 and I have three workbooks - Book1.xlsm, Book2.xlsm, and Book3.xlsm. All three of these workbooks are open at the same time. What I'm looking for is...

    If there's no activity on Book1, count 5 seconds and show Book2.
    If there's no activity on Book2, count 5 seconds and show Book3.
    If there's no activity on Book3, count 5 seconds and show Book1.

    So if someone is looking at the computer screen and not making changes to the workbooks or moving the mouse, it'll open the next workbook in 5 seconds.

    Is such a thing possible?

    Thanks in advance.
    Last edited by Subject_Name_Here; 01-28-2013 at 05:50 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1