I've made an Excel-file with several sheets which contain hyperlinks to navigate from one page to another.
I wanted to protect the sheets to prevent accidental changing of the data on the sheet. At first my file because useless because the hyperlinks didn't function anymore. Therefore I unlocked every hyperlink cell and protected the sheet again. Now I'm able to navigate through the workbook with the hyperlinks.
There is one problem though; When I activate a sheet, the last selected cell of that sheet is still selected and that doesn't look very nice in my opinion.
I would like that no cell is selected when the sheet is activated (Like a sheet that is proteced of selecting locked and unlocked cells)
If this isn't possible i would like to always select the same, unlocked cell, so that there is some kind of standard.
I tried using the following code, but no succes:
A1 is a locked cell: When the sheet is protected the last selected cell remains selected. When the sheet isn't protected cell A1 is selected.
Cell C5 is the unlocked cell that could be selected if it isn't possible not to select any cell. I suppose it is no problem that this cell is merged?
And while we're at it:
Is it possible to always show the sheet from the first row down when activating it (Regardless of the view of the sheet when activating another sheet?
I hope somebody can help, just tell me if no solution is possible.
Bookmarks