How to make two cells clickable (all other cells are NOT clickable)?

**niuyuer** · 05-16-2016, 12:07 PM

Activesheet.Range("B6").Select
Selection.Locked = False

Activesheet.Range("B11").Select
Selection.Locked = False

Then lock whole worksheet

---------------------------------------

Both B6 and B11 are hyperlinks, so I want people can click the link. But my code can only keep B11 unlocked. In other words, people can only click hyperlink in B11.

If I remove (Activesheet.Range("B11").Select
Selection.Locked = False), then people can click the hyperlink in B6.

How can I keep both B6 and B11 unlock, and people can click either one of the cells?

How to select multiple cells (not next to each other)?

Thanks.

**niuyuer** · 05-16-2016, 12:14 PM

Activesheet.Range("B6", "B11").Select
Selection.Locked = False

This does not work either, it can only keep B6 unlocked.

**FDibbins** · 05-16-2016, 12:51 PM

I have just tested, and HL works on locked cells, so it looks like you dont even need to do what you are trying?

**shg** · 05-16-2016, 12:56 PM

How to select multiple cells (not next to each other)?

Please Login or Register  to view this content.

But there's no need to select cells to operate on them.

**niuyuer** · 05-16-2016, 01:01 PM

Originally Posted by FDibbins

I have just tested, and HL works on locked cells, so it looks like you dont even need to do what you are trying?

Activesheet.Hyperlinks.Add Anchor:=Activesheet.Cells(6, 2), _
Address:=wkbook.FullName, TextToDisplay:=wkbook.FullName

Actually, I mean two file links (two separate files in my Drive). I cannot let people to click both links, only one link works.

**niuyuer** · 05-16-2016, 01:08 PM

Originally Posted by shg

Please Login or Register  to view this content.

But there's no need to select cells to operate on them.

Activesheet.Range("B6, B11").Locked=False

Without .Select, I got error message 1004 "Unable to set the Locked property of the Range class"

**niuyuer** · 05-16-2016, 01:14 PM

Activesheet.Range("B6, B11").Select
Selection.Locked = False

Neither link is clickable.

**niuyuer** · 05-16-2016, 01:24 PM

Maybe my question is not related to unlocked two cells. I should ask: how to make multiple hyperlinks clickable in a protected sheet.

**niuyuer** · 05-16-2016, 01:53 PM

Anyone know how to make two file links clickable, while all other cells are protected?

**niuyuer** · 05-16-2016, 02:39 PM

What I want is: only two cells are clickable, all other cells are NOT clickable.

Please Login or Register  to view this content.

**niuyuer** · 05-16-2016, 02:55 PM

Can anyone help me make A9 and A14 clickable, while all other cells are NOT clickable.

Mine code does not work:

ThisWorkbook.Sheets("TestSht").Protect Password:="pswd", DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:=True

**Cdubisms** · 05-16-2016, 04:00 PM

I'm confused. Why not just select the cells in which the hyperlinks reside, go to "format cells">"Protection">uncheck "Locked", then protect the sheet, only leave "select unlocked cells" checked?

That way the only cells they can click on are the ones that hold the hyperlinks.

I don't think a macro is necessary here.

How to make two cells clickable (all other cells are NOT clickable)?

LinkBack

Thread Tools

Rate This Thread

Display

How to make two cells clickable (all other cells are NOT clickable)?

Re: How to unlock two cells (not next to each other)?

Re: How to unlock two cells (not next to each other)?

Re: How to unlock two cells (not next to each other)?

Re: How to unlock two cells (not next to each other)?

Re: How to unlock two cells (not next to each other)?

Re: How to unlock two cells (not next to each other)?

Re: How to unlock two cells (not next to each other)?

Re: How to unlock two cells (not next to each other)?

Re: How to unlock two cells (not next to each other)?

Re: How to unlock two cells (not next to each other)?

Re: How to make two cells clickable (all other cells are NOT clickable)?

Thread Information

Users Browsing this Thread

Similar Threads

how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.

[SOLVED] how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.

[SOLVED] how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.

how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.

how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.

[SOLVED] how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.

[SOLVED] how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.

[SOLVED] how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro.

Bookmarks

Bookmarks

Posting Permissions