Making functions available in a protected worksheet

S

sdrane

Hi

I am running Excel 2000. I have a protected worksheet that I share wit
a number of users in my organisation. Certain function don't operat
when the sheet is protected. I have found code that allows filtering t
be used, but would like to find code to allow the insertion of
hyperlink on a protected sheet.

Can this be done through a worksheet activate code. My current cod
includes

Sub Worksheet_Activate()

ActiveSheet.EnableAutoFilter = True
ActiveSheet.Protect contents:=True, userInterfaceOnly:=True

End Sub


If possible, I would like to be able to set a valid path for th
hyperlinks by referring to a pathname stored on a cell on th
worksheet, as well as being able to limit the type of hyperlink to
file, with a mask structure (eg z-*.xls).

Would appreciate your help.

Thanks
Stev
 
Top