Hi

This is my first post and would appreciate any help.

I am currently developing a spread sheet, excel 2010, that will be used by other people, not shared. I need to protect the sheet to protect standard content and formulas etc.
I need the users to be able to open and close grouped cells when the sheet is protected but I also need them to be able to insert hyperlinks in the cells that are unlocked.
I am currently using the below in VBA

With Worksheets("QCF")
.Unprotect "3d3n123"
.EnableOutlining = True
.Protect "3d3n123", contents:=True, userInterfaceOnly:=True
End With

This allows grouped cells to be opened and closed when sheet it protected but I cannot figure out how to allow option to insert hyperlinks on the unlocked cells when sheet is protected. I am still pretty new to using VBA, I got the above from another forum.

Please help!

Regards
Scott