I am looking for a solution on how to automatically open an Excel hyperlink directly in incognito mode.

For example, say I have the following hyperlink in column A =HYPERLINK("https://www.amazon.com/s?k=" & H3, "AMR ALL") this will open a new tab in my default web browser (Edge) however I would need to open these types of hyperlinks directly in a private window or tab. I need to specify that there are hundreds of similar hyperlinks that I need to open (quite frequently) and it's almost impossible to copy & paste these links every time - hence why I'm looking for a solution.

I have already tried setting up a Desktop shortcut for Microsoft Edge that opens ion private (incognito) directly to the main URL i.e. =HYPERLINK("C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe" -in private "https://www.amazon.com/s?k=") however I will need the URL to pick additional information from a different cell in Excel i.e. H3 and then open the link in incognito. Not sure how I can achieve this and I would appreciate it if anyone would be able to help me out with this.

Thanks, everyone :)

CodePudding user response：

I found a way to accomplish this. Create a desktop shortcut. In that shortcut have it direct to the browser. I did it with Chrome, so mine looked like:

"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"

Then after the link to the browser is done add the switch to open in Incognito (may differ for browser). For Chrome it is -incognito

You then add the link you want to open, placing it inside quotes.

"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" -incognito "http://yourlinkhere.com"

In Excel you will link to the shortcut. It will give you warning boxes but those are easy enough to close. If anyone knows how to make a macro to disable them for just this click then I would like to know.

CodePudding user response：

2 Solutions:

• Right-click on the link, and then press the letter "g" on the keyboard. It's almost as fast as just clicking the link.

• Alt Shift Click on Link.