Forum Discussion
Solved
Unlocked cells get locked after inserting text/hyperlink
Hi, I'm trying to make a table where users can insert names of products in one column and hyperlinks for the products in another column. The problem is, when I lock the sheet (of course I leave the...
martyst Tried that. Same result. But pasting as values and then reconfirm does the trick.
Riny_van_Eekelen Thank you for the reply. I copy the hyperlink from Google Chrome's adress bar.
The text is from the product's web page.
You are right, pasting it without keeping the source's format doesn't lock the cell (but removes the hyperlink as you've said).
This seems very strange.
martyst Tried that. Same result. But pasting as values and then reconfirm does the trick.
Riny_van_Eekelen Yes, right clicking and pasting it using the little arrow and then latest in the "hyperlink" option makes it work. Still a bit odd.
Thank you so much!