ActiveWorkbook.FollowHyperlink doesn't work after protection

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?


Please try to replace ActiveWorkbook.FollowHyperlink calls by
Shell "explorer """ & Range("AT47") ' replace URL by yours

Great! Now it works properly.

I used:

Shell "explorer """ ' replace URL by yours

Thank you

1 Like