How to open hyperlinks present in cells in excel at regular interval (eg. 10 seconds) using Macro.
At work I have to open 100 links one by one, all the links should open in order without overlapping each other.
It is really painful to open each link one by one by clicking, can anyone help me please
Last edited by pari9485; 03-09-2013 at 07:41 PM.
I think this is what you need. You can adjust the time between opening the sheets by changing the 5 to 3 or 4 or 6 or 7 500000000 higher is slower. Macro is in the attachement.
Please Login or Register to view this content.
Yes it will. we just have to figure out how...
If I have helped you, PLEASE click the * and add to my Rep.
Also, if the problem is SOLVED please mark it as so.
Thanks a lot, It works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks