VBA link to another spreadsheet throws RTE 1004 if file is in use

Hello, looking for some guidance with links to other excel spreadsheets. I have been asked to compile a 'dashboard' that simplifies searching for files by having hyperlinks to them all in one place. This seemed easy enough and entered simple code for each command button, what I did not account for whether anyone else on the network would be using any of the files. If indeed they are VBA throws up a RTE 1004 error (Select Method Of Worksheet Class Failed) but I would simply like it to let users choose as they would normally (when excel reports file is locked for editing) to open read only/notify/cancel as normal.

Here is the basic code for the buttons;

Please Login or Register  to view this content.

What could I add so that if indeed a file is in use the code would offer me the same options as if I was opening the file directly?

Edit: By just putting a plain hyperlink into a cell will open up the targetted workbooks without a problem so that is why I am confused as to why it is not opening via VBA?

Many thanks.