Microsoft Excel 2010

Good Afternoon Guys,
We have a spreadsheet that all users have access to but there is a issue once a user tries to open a link within the spreadsheet.
Error as follows:-
Run-time error '1004' - Unable to set the visible property of the Worksheet class
Has anyone came across this and is there an easy fix?
Thanks for you help.
Rob
We have a spreadsheet that all users have access to but there is a issue once a user tries to open a link within the spreadsheet.
Error as follows:-
Run-time error '1004' - Unable to set the visible property of the Worksheet class

Has anyone came across this and is there an easy fix?
Thanks for you help.
Rob