Paste As A Hyperlink On A Protected Worksheet

John Brown · Feb 16th 2007

I have a protected worksheet that I want users to be able to use the 'Paste as a Hyperlink' function. How can I do this without having to unprotect the sheet?

Many thanks,
John

Simon Lloyd · Feb 16th 2007

Re: Paste As A Hyperlink On A Protected Worksheet

Here's a worked example from sheet 1 to sheet 2

Code

Sub Macro2()


    Selection.Copy
    Sheets("Sheet2").Select
    ActiveSheet.Unprotect Password:="1234"
    Range("C1").Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
                               "Sheet1!A1", TextToDisplay:="Sheet2!A1"
    ActiveSheet.Protect Password:="1234"
    Sheets("Sheet1").Select
    Application.CutCopyMode = False
End Sub

Display More

Regards,
Simon

John Brown · Feb 16th 2007

Re: Paste As A Hyperlink On A Protected Worksheet

Thanks Simon,
but I need the user of the worksheet to be able to hyperlink a word document to unprotected cells.

John

Anonymous · Feb 16th 2007

Re: Paste As A Hyperlink On A Protected Worksheet

John, Welcome to the forum. Do you want this moved to the Word forum?

John Brown · Feb 16th 2007

Re: Paste As A Hyperlink On A Protected Worksheet

Not really because it is about how I can get excel to let me use the function 'Paste as a hyperlink' on a protected worksheet. When the worksheet is not protected I can simply highlight a part of the word document, copy it and then, in my chosen excel cell, select [Edit/Paste as a Hyperlink] and it places the link in the cell for future recall of the word document. I just can't get it to do this when the sheet is protected.

Many thanks,
JOhn

Simon Lloyd · Feb 16th 2007

Re: Paste As A Hyperlink On A Protected Worksheet

John i think you may find that it would be more beneficial to you for this to be moved to the Word Forum as you are trying to manipulate Excel from Word not the other way around, unfortunately i know nothing of WOrd scripting.

Regards,
SImon

John Brown · Feb 16th 2007

Re: Paste As A Hyperlink On A Protected Worksheet

It's up to you, but I don't think that someone with word experience would necessarily be able to advise how to enable the Excel function of 'Paste as a Hyperlink' to work on a protected Excel worksheet. However, if you think it would be the right place, then please feel free to move it.

Many thanks, Simon,

John

Anonymous · Feb 16th 2007

Re: Paste As A Hyperlink On A Protected Worksheet

Let's see if someone in the other forum can help. Moving to Word.

jjessary · Feb 17th 2007

Re: Paste As A Hyperlink On A Protected Worksheet

I'm no expert, but I don't think you can make that change to the cell contents while the sheet is protected. You could however, write a macro that would unprotect the sheet, paste the information, and then protect the sheet again. This would allow your user to paste the hyperlink without being able to make other changes.

Paste As A Hyperlink On A Protected Worksheet

Participate now!

Share