How can I suspend macro code until I return to Excel after my macro navigates to a website

[jerry12302]

I have code to copy a website Login ID, then open Chrome and navigate to a website where I can paste my Login ID to log in. After returning to Excel it still has the Login ID range in copy mode and I have to press Escape. If I add Application.CutCopyMode = False after the code that navigates to the website, I lose the Login ID copy.

How can I have Excel pause macro execution until after I return to Excel?

Here is the code I use (modified to be a sample):

Sub ABC_Website_Login()

Dim chromePath As String
Range("LoginID").Copy

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

Shell (chromePath & " -url https://www.somewebsiteIuse.com/login")

'Need some code here to suspend the macro until I return

Application.CutCopyMode = False

End Sub

 

[EFANYoutube]

Hi jerry
This will put the .value of the cell straight into the clipboard and not the whole cell meaning no marching ants to get rid of

Sub ABC_Website_Login()

Dim chromePath As String
Dim CBoard As Object
Set CBoard = CreateObject("HtmlFile")
  CBoard.ParentWindow.ClipboardData.SetData "text", Range("LoginID").Value

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

Shell (chromePath & " -url https://www.somewebsiteIuse.com/login")

End Sub

 

[jerry12302]

Thank you EFAN, that works great.

 

[EFANYoutube]

Thank you EFAN, that works great.

Hey,
Would you mind marking an answer