+ Reply to Thread
Results 1 to 3 of 3

Hyperlinks will only work if book is unprotected

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

    Hyperlinks will only work if book is unprotected

    Hello Again
    I've been searching all the 'hyperlink' posts but nothing the same as my problem unfortunately.
    I have attached a sample workbook. My problem is that I have put hyperlinks on my sheet and they take me to other parts of the same sheet, they work prefectly when the document is unprotected but as soon as I protect it they don't work at all, although the cusor does still change to the 'hand' symbol. I have tried unlocking the cells but it doesn't make any difference.
    Any help would be very welccome
    Thanks
    Attached Files Attached Files
    Last edited by nje; 07-16-2010 at 11:20 AM.

  2. #2
    Registered User
    Join Date
    06-01-2010
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Hyperlinks will only work if book is unprotected

    Hi,

    When you protect the sheet, just make sure 'select locked cells' is selected. This should fix your problem.

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

    Re: Hyperlinks will only work if book is unprotected

    Thanks, I have been messing about now for nearly two hours and had missed the obvious.
    I used blank cells as the 'anchor cells' and I had not unlocked them so the hyperlink wouldn't go there. As soon as I unlocked them they work perfectly.

+ 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