#1   Report Post  
Posted to microsoft.public.excel.misc
John Calder
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink Function Problem PCLIVE Excel Discussion (Misc queries) 1 October 8th 05 12:54 AM
hyperlink problem Keith G Hicks Excel Discussion (Misc queries) 1 September 20th 05 10:03 PM
Using the Hyperlink Function and finding filenames Jeni Q Excel Worksheet Functions 0 September 20th 05 02:37 PM
Importing Access File with Hyperlink B.C.Lioness Excel Discussion (Misc queries) 0 April 29th 05 10:13 PM
Hyperlink to a word document JS Excel Discussion (Misc queries) 1 December 10th 04 11:49 PM


All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"