Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Allowing hyperlinks an a protected sheet
Hi,
I am using Excel2003 to create a workbook for use by a group of people who need some access but not to alter criteria. code, formulas etc. Using simple VBA code I have set things up to enable outlining and then protect the two worksheets, the only problem is that this then sets the protect to Excel defaults and so I cannot enable the insertion of hyperlinks by end-users. I have had a play, but profess to being a little bit of a macro newbie. Any help very gratefully received. |
#2
|
|||
|
|||
Allowing hyperlinks an a protected sheet
Try protecting the worksheet manually (in fact, record a macro when you do it to
get the code). You'll see that xl2002+ (including xl2003) has an option to allow users to insert hyperlinks in that Tools|protection|protect sheet dialog. Chris Ince wrote: Hi, I am using Excel2003 to create a workbook for use by a group of people who need some access but not to alter criteria. code, formulas etc. Using simple VBA code I have set things up to enable outlining and then protect the two worksheets, the only problem is that this then sets the protect to Excel defaults and so I cannot enable the insertion of hyperlinks by end-users. I have had a play, but profess to being a little bit of a macro newbie. Any help very gratefully received. -- Dave Peterson |
#3
|
|||
|
|||
Allowing hyperlinks an a protected sheet
Thanks very much, worked fine. Also found I could alter the properties by
using the "Allow Users to Edit Range" options. Thanks again, Chris "Dave Peterson" wrote: Try protecting the worksheet manually (in fact, record a macro when you do it to get the code). You'll see that xl2002+ (including xl2003) has an option to allow users to insert hyperlinks in that Tools|protection|protect sheet dialog. Chris Ince wrote: Hi, I am using Excel2003 to create a workbook for use by a group of people who need some access but not to alter criteria. code, formulas etc. Using simple VBA code I have set things up to enable outlining and then protect the two worksheets, the only problem is that this then sets the protect to Excel defaults and so I cannot enable the insertion of hyperlinks by end-users. I have had a play, but profess to being a little bit of a macro newbie. Any help very gratefully received. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Protected sheet to unprotected sheet | Excel Worksheet Functions | |||
refresh external data on a protected sheet | Excel Discussion (Misc queries) | |||
Hyperlinks - identifying source in destination sheet | Excel Discussion (Misc queries) | |||
How to enable grouping in a protected sheet | Excel Worksheet Functions |