Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
i have inserted a hyperlink in my excel sheet
what should i do now in order to protect this link and prevent someone to open it ???...password maybe ???....any suggestions??? THANK YOU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
I don't think you can password protect a hyperlink. You should perhaps use
a button or some other control or shape. You can attach a macro to it that asks for a password. Of course a determined person could get into your code and discover the password or see what the code does. -- Jim "pierre" wrote in message ... i have inserted a hyperlink in my excel sheet what should i do now in order to protect this link and prevent someone to open it ???...password maybe ???....any suggestions??? THANK YOU |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlink
You could unlock all cells except for that hyperlink cell then protect the
sheet with "select locked cells" disabled. Add a password to unprotect. Note: Excel's internal security is quite weak and passwords easily cracked. Gord Dibben MS Excel MVP On Sat, 6 Sep 2008 08:11:01 -0700, pierre wrote: i have inserted a hyperlink in my excel sheet what should i do now in order to protect this link and prevent someone to open it ???...password maybe ???....any suggestions??? THANK YOU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |