Re: Unblock Excel

Excel Help for re: Unblock Excel in Presenting and Reporting Data

Find Excel Solutions


Search the Forums:
Recent Activity:
Delete Cell Items In Spreadsheet
Importing Data From Pdf Files
New Portfolio Optimization Template Version
Financial Market Data Feed
Run Time Error 1004
Data Downloader Crashes Excel




Follow Business Spreadsheets On:
 
Forum TopicLogin
re: Unblock Excel
Rate this:
(3/5 from 1 vote)
ConfusedThis is just a guess -  

To do this task you will need a macro.
You will have to initiate the hyperlink from within the macro so that you can count the time it takes to load. You will need to include code that can check the browser address so that it matches partof your hyperlink. I say this because most sites change the url by adding extrabits that may contradict your original link.

If there is no match for more that 5 seconds then
range("A1").select

This might redirect the attention back to Excel.

I haven't tested this yet as it will require some nail-biting, hair-pulling, chain-smoking coding.

 Posted by on
[View the Full Thread for the "Unblock Excel" Topic]

Find relevant Excel templates and add-ins for re: Unblock Excel in the

 
Find Excel templates
and add-ins in the
Excel Business Solutions Directory

       
  © 2013 Business Spreadsheets. All Rights Reserved. Legal | About Us