ActiveWorkbook.FollowHyperlink doesn't work after protection

XLS Padlock
#1

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.

#2

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

#3

Please try to replace ActiveWorkbook.FollowHyperlink calls by
Shell "explorer ""https://www.mysite.com/perl/chessgame?gid=" & Range("AT47") ' replace URL by yours

#4

Great! Now it works properly.

I used:

Shell "explorer ""https://www.mysite.com/" ' replace URL by yours

Thank you

1 Like