tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
Ok i'll try not to confuse the situation by explaining why I need this done, i'll just say it vital for what I'm trying to do.
So what I need is a macro that will double click a cell so the curser is in it then click enter so it moves out!
If you want I little move detail here goes but please don't get confused by this part!
I have a list of websites without hyperlinks in column A,
when I double click the cell with the webaddress in it then press enter it turns the webaddess into a hyperlink,
I need this done on about 2000 lines so I need a macro that will simulate double clicking or entering into the cell then pressing enter
if you want to test what I'm talking about put www.bbc.com into a cell right click and remove the hyperlink,
Then double click on the cell and the curser goes into the cell, not selecting the cell but inside it so you can edit the contents, now press enter and the cell with get a hyperlink,
this is what I want.
any ideas how I would do this?
Tony
Ok i'll try not to confuse the situation by explaining why I need this done, i'll just say it vital for what I'm trying to do.
So what I need is a macro that will double click a cell so the curser is in it then click enter so it moves out!
If you want I little move detail here goes but please don't get confused by this part!
I have a list of websites without hyperlinks in column A,
when I double click the cell with the webaddress in it then press enter it turns the webaddess into a hyperlink,
I need this done on about 2000 lines so I need a macro that will simulate double clicking or entering into the cell then pressing enter
if you want to test what I'm talking about put www.bbc.com into a cell right click and remove the hyperlink,
Then double click on the cell and the curser goes into the cell, not selecting the cell but inside it so you can edit the contents, now press enter and the cell with get a hyperlink,
this is what I want.
any ideas how I would do this?
Tony