Can't click hyperlink in locked cells.

Re: Can't click hyperlink in locked cells.

If you mean by the "Hyperlink" formula? Yes... Protect/Lock all cells as before.

Protect the worksheet and allow the user to select locked and unlocked cells.

You should still be able to click on hyperlink-ed function cells.

Ger

Re: Can't click hyperlink in locked cells.

Then, no You need to change the protection type on the sheet to allow users to select cells.

(or use a =HYPERLINK function in the cell instead).

Ger

Re: Can't click hyperlink in locked cells.

Try this
Use the range to unlock the cells which contains hyperlink

Sub test()
Range("A1:A10").Locked = False
ActiveSheet.Protect "pass"  ''''---->password for sheet
 
End Sub

Hope this helps

Re: Can't click hyperlink in locked cells.

can you let me know that the answer provided to you firstly solved your issue?

the error is due to no cells range .Cells(A, "AV") ---> this is not the proper way

cells(0,"AV") or someother values inside the bracket

try something like this easy and works for me every time

tool.Worksheets("TRB Database").range("Enter Range here").Formula = "=HYPERLINK("" & URLText & "", " & CStr(ThisWorkbook.Worksheets("Design Calculator, Q").Cells(21, "P").Value) & ")"

Re: Can't click hyperlink in locked cells.

To avoid confusion use CHR(34) more for Double Quotes... Something like this:

Public Sub test()


Dim urltext As String
urltext = "https://www.google.com"


ActiveSheet.Cells(1, 1).Formula = "=HYPERLINK(" & Chr(34) & urltext & Chr(34) & "," & Chr(34) & CStr(Worksheets(1).Cells(1, "P").Value) & Chr(34) & ")"


End Sub

(I had to change your cell locations to get it working really quick)
Ger

Re: Can't click hyperlink in locked cells.

please provide your code so far that i can help you further

Re: Can't click hyperlink in locked cells.

pleasure providing the solution to you

great work Ger Plante:congrats:

Re: Can't click hyperlink in locked cells.

Thx.... Team effort rules the day