Protected cell with Hyperlink

Ralphnet

New Member
Joined
Nov 26, 2005
Messages
32
Hi, is there a way to have an active Hyperlink in a Protected cell that can not be deleted by another office worker ? Thank You, Ralph
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
If the cell is protected & you lock the worksheet or workbook with a password, this should prevent any deletion or change to that worksheet/book.

See Excel help on protection or google it.
 
Upvote 0
If the cell is protected & you lock the worksheet or workbook with a password, this should prevent any deletion or change to that worksheet/book.

See Excel help on protection or google it.

I have a lot of unlocked cells on the sheet also. I need the hyperlink to work and remain locked so that people can not delete it when using the sheet for turn ins. Ralph
 
Upvote 0
lionelnz is correct that this approach is best.

If you only have a few cells to protect follow these steps:

1: Highlight all cells on given sheet by clicking the box above and to left of A1.

2: Go to Format --> Cells --> Protection --> set all to Unlocked.

3: Now select those cells you wish to protect repeating step 2 but this time set to Locked.

4: Protect your Worksheet with a password.

5: Save your file.
 
Upvote 0
Ok but I want the Hyperlink to work and I wondered if that could be done without having the box (Checked) that states allow users to select locked cells?
 
Upvote 0
Allowing users to "Select Locked Cells" does not permit the users to change the values within.
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,316
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top