| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting a hyperlink into a protected worksheet
I have produced a spreadsheet that requires input from other people to
complete it. I have protected the structure leaving certain cells for input. One of these requires the user to insert a hyperlink but although the lock is off that cell, because the worksheet is protected, it will not allow me to do it. Is there a way around this without losing the protection? -- Tony |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Putting a hyperlink into a protected worksheet
Remove protection and then reapply it to the worksheet, only this time in the
list of ALLOW USERS OF THIS WORKSHEET TO check INSERT HYPERLINKS -- Kevin Backmann "Tony" wrote: I have produced a spreadsheet that requires input from other people to complete it. I have protected the structure leaving certain cells for input. One of these requires the user to insert a hyperlink but although the lock is off that cell, because the worksheet is protected, it will not allow me to do it. Is there a way around this without losing the protection? -- Tony |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Putting a hyperlink into a protected worksheet
Kevin B
Thanks, it now works - it's easy when you know how! Thanks again. -- Tony "Kevin B" wrote: Remove protection and then reapply it to the worksheet, only this time in the list of ALLOW USERS OF THIS WORKSHEET TO check INSERT HYPERLINKS -- Kevin Backmann "Tony" wrote: I have produced a spreadsheet that requires input from other people to complete it. I have protected the structure leaving certain cells for input. One of these requires the user to insert a hyperlink but although the lock is off that cell, because the worksheet is protected, it will not allow me to do it. Is there a way around this without losing the protection? -- Tony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| install a hyperlink in a protected workbook | Excel Worksheet Functions | |||
| Protected cell performing hyperlink | Excel Discussion (Misc queries) | |||
| Wierd!!!!?? Protected and shared - cant insert hyperlink | Excel Discussion (Misc queries) | |||
| Mouse pointer becomes hyperlink when sheet protected | Excel Discussion (Misc queries) | |||
| Protected Hyperlink | New Users to Excel | |||
Linear Mode
