I am trying to automate a task with a macro recorder where I open a hyperlink in a cell in a spreadsheet, save the displayed page then move to the next cell and repeat. The problem I am experiencing is when I use the mouse to click the hyperlink, the recorder always goes back to the first cell I clicked when recording the session.

I need to use keystrokes to open the hyperlink. I have not found a solution as of yet on how to open the web page with anything other than a mouse. Any suggestions would be most welcome.

Terry