Hello,
I was wondering if I can create a hotkey (preferably the space bar) to open the link when I'm clicked on a cell? I have several thousand URLs in one column and I want to be able to scroll up and down them to open without using a mouse in the quickest way possible.
Thank you.
The code on normal module :
The code on sheet module :
Please Login or Register to view this content.
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Thanks. However, it's no better this way, because my after pressing the space bar it leaves Excel for the webpage. Do you know how to correct this?Originally Posted by karedog
The code on normal module :
The code on sheet module :Please Login or Register to view this content.
Please Login or Register to view this content.
This is something unavoidable, even if you click the link manually, the focus will be changed to opened browser. This also applied to all other windows programs.
One way to overcome this, is by waiting for a small amount of time (to give the browser time to load), and then switched back to Excel.
You cannot fast "spacing" and hoping the browser processes in background (like you open the webpage from bookmark), since this is an automated with multi process involved (not single process by browser itself).
Change sub DoHyperlink to this :
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks