VBA to open password protected sheet via hyperlink

[Godders199]

I use the following code to open a workbook to pull information, this workbook as been password protected .So I need to alter the code to include the password.

Range("A85").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

I have searched the internet, but cannot find any examplesof opening a password protected workbook with a hyperlink .

I have tried the obvious, adding ,Password:=”” to the end


Does anyone know the code I need to insert for thepassword.?

Any help appreciated.

 

[daverunt]

I don't think that's do-able as there is no parameter in the method for a password.

https://docs.microsoft.com/en-us/office/vba/api/excel.hyperlink.follow

Maybe someone will respond that uses a different technique to achieve what you are after.