Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm using Excel 2003. I have locked all of the cells in a worksheet except
for 2. Each of the two unlocked cells contain a hyperlink. I then protected the worksheet and content of locked cells with none of the checkboxes selected. I do not want the reader of my document to be able to do anything more than read and click on the two hyperlinks. Problem: I've done this in two separate documents (trying to find a solution, but I failed). In the first document, the hyperlinks in the two unlocked cells are not clickable, even though I have them unlocked. In the second document, when you click on any of the cells (including the locked/protected cells), it takes you to one of the hyperlinks that are found in the two unlocked cells. It is seemling random which one of the two you will be taken to, but once you click and are taken to one of the two hyperlinks, that choice seems to be persistent while you have the document open. It may choose the other link after you close and open the document and try linking again. The two documents are very similar. I copied the first to create the second after discovering the problem. It does not seem to make a difference if I use a password with the protection or not. Question: How do I setup the document to protect all of the cells except for the two cells with hyperlinks and have the hyperlinks actually work after the worksheet is protected? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Tabing through cells on a protected worksheet | Excel Discussion (Misc queries) | |||
protected sheet arrow keys not working on unlocked cells | Excel Discussion (Misc queries) | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
Protected Worksheet - tabs stop working in certain areas | Excel Discussion (Misc queries) |