Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Cincinnati, Ohio
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Allow hyperlink editing in protected worksheet (2002)

    Is there a way to allow a user to edit an inserted hyperlink in a protected worksheet? The cell that contains the hyperlink is unlocked. Thank you. -scott

  2. #2
    Star Lounger
    Join Date
    Mar 2004
    Location
    Essex, England
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Allow hyperlink editing in protected worksheet (2002)

    The hyperlink formula contains two parts:- e.g " =HYPERLINK(Sheet 1!$A$1,A1)" means that the actual hyperlink is taken from cell a1 in worksheet 1and the "friendly" name (the text that appears in the cell, is taken from cell a1 in the protected worksheet.

    Therefore you could allow people to edit the cell in worksheet 1, whilst keeping your protected workksheet safe

    Regards

    Robert

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Allow hyperlink editing in protected worksheet (2002)

    You will have to either create a macro to first unprotect the sheet to allow editing then reprotect

    or do as Robert suggested and place hyperlink formula in the cell (protect this cell) and have the "reference" to the link in another (unprotected cell) to allow editing.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •