View Single Post
  #1   Report Post  
Chris Ince
 
Posts: n/a
Default 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.