S
SAP PoD
Hi,
I have a protected sheet, with a few unprotected cells. One of th
cells (say, E6) has a simple hyperlink back to Sheet1. My problem i
that when a protected cell is selected, it executes whatever hyperlin
is in E6.
I have tried working round the problem by making the hyperlink in E
point back to it's own worksheet and creating another hyperlin
elsewhere to return to Sheet1 (which is a Return to Main men
function). Same problem occurs, which seems a little odd to me.
I have also tried unprotecting A1 (and testing with a dummy hyperlink
as I read somewhere that it may be jumping to the first unprotecte
cell. Same problem.
Any ideas
I have a protected sheet, with a few unprotected cells. One of th
cells (say, E6) has a simple hyperlink back to Sheet1. My problem i
that when a protected cell is selected, it executes whatever hyperlin
is in E6.
I have tried working round the problem by making the hyperlink in E
point back to it's own worksheet and creating another hyperlin
elsewhere to return to Sheet1 (which is a Return to Main men
function). Same problem occurs, which seems a little odd to me.
I have also tried unprotecting A1 (and testing with a dummy hyperlink
as I read somewhere that it may be jumping to the first unprotecte
cell. Same problem.
Any ideas