Inserting Hyperlinks in a Protected Sheet

  • Thread starter Thread starter sdrane
  • Start date Start date
S

sdrane

Hi

I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.

3 Questions:

1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?

2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?

3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?

Would appreciate your suggestions.
Thanks Stev
 
Hi Steve,
If you have Excel2003 you can permit (as an option) insertion of hyperlinks
on a protected sheet.
 
Back
Top