+ Reply to Thread
Results 1 to 5 of 5

How to get my hyperlinks to work when sheet is protected, 2 work, 2 don't??

  1. #1
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    How to get my hyperlinks to work when sheet is protected, 2 work, 2 don't??

    In the attached example there are 4 hyperlinks, All four work when the sheet is unprotected, but only the two that go down the sheet work when the sheet is protected and the two coming back up the sheet don't.
    I've spent ages inserting and deleting and scouring the forum for an answer but can't find one. probably something stupid that I'm missing but, can anyone advise please?
    Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-25-2008
    Location
    Poland
    MS-Off Ver
    MSO 2K3, 2K10
    Posts
    84

    Re: How to get my hyperlinks to work when sheet is protected, 2 work, 2 don't??

    Quote Originally Posted by nje View Post
    (...) two coming back up the sheet don't.
    When you protected sheet you don't allow to select locked cells.
    But cell A1 is locked.

    BTW. Cells B26 and B122 are locked too.

    Artik

  3. #3
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    Re: How to get my hyperlinks to work when sheet is protected, 2 work, 2 don't??

    Artik_PL - Thanks, with hindsight the solution was obvious! but it had been driving me mad. Thanks for pointing it out to me, I appreciate it. Also thanks for spotting the other two locked cells, B26 and B122, how did you notice that, is there a way of checking which cells are locked?
    Thanks again

  4. #4
    Registered User
    Join Date
    11-25-2008
    Location
    Poland
    MS-Off Ver
    MSO 2K3, 2K10
    Posts
    84

    Re: How to get my hyperlinks to work when sheet is protected, 2 work, 2 don't??

    Quote Originally Posted by nje View Post
    how did you notice that, is there a way of checking which cells are locked?
    I run this macro:
    Please Login or Register  to view this content.
    And you can see at a glance

    Artik

  5. #5
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    Re: How to get my hyperlinks to work when sheet is protected, 2 work, 2 don't??

    Thanks again, I'll use that in the future

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1