Dear sirs,
the vba code that opens a web page address using the method ActiveWorkbook.FollowHyperlink doesn’t work after the creation of the protected file. When I run the routine, anything happens.
In the unprotected Excel file it works properly.
How can I fix that?
Thanks in advance.
To better understand the issue and to perform a test you can download a sample file I created (unprotected workbook and protected workbook), from dropbox link:
download sample file
On my pc it doesn’t work, what happens on yours?
Thanks
Marco
Please try to replace ActiveWorkbook.FollowHyperlink calls by
Shell "explorer ""https://www.mysite.com/perl/chessgame?gid=" & Range("AT47") ' replace URL by yours
Great! Now it works properly.
I used:
Shell "explorer ""https://www.mysite.com/" ' replace URL by yours
Thank you
1 Like