Hyperlink Problem
Hi
I have posted this question in the Excel area but have not recieved any
replies, maybe someone here can help.
I run Win200 with Excel 2000. I have a spreadsheet that is protected. Some
of the cells are not locked so that information can be entered into them.
When I copy a hyperlink from an external program and paste it into the
unprotected cell it works fine. The problem I have is that if I decide to
delete this hyperlink then I get an error message telling me that the cell is
protected and that I have to remove the protection to allow me to delete the
cell.
If I remove the protection the hyperlink can be deleted. Can anyone tell me
why the pasted hyperlink becomes "protected" when I paste it into an
unprotected cell?
Is the any way that this problem can be overcome?
Any help will be much appreciated.
Thanks
John
|