Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Remove link to formula source

After I protect my spreadsheet, double-clicking on locked cells that contain
formulas sends the user to cells that are referenced in the formula.
How can I prevent this from happening?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Remove link to formula source

Make sure that the cells are locked in a way that prevents the user from
selecting them.
--
Gary''s Student - gsnu200834


"lshirman" wrote:

After I protect my spreadsheet, double-clicking on locked cells that contain
formulas sends the user to cells that are referenced in the formula.
How can I prevent this from happening?


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
How to remove the file link from the formula? Jignesh Gandhi Excel Worksheet Functions 4 May 10th 23 07:44 PM
How to remove an external data source Dinesh New Users to Excel 1 August 22nd 08 08:31 PM
edit link source Joel Excel Discussion (Misc queries) 1 April 14th 08 09:31 AM
Changing the source of a link zhj23 Excel Discussion (Misc queries) 3 June 24th 07 02:34 PM
Renaming a Source Link Arla M Links and Linking in Excel 5 February 9th 05 08:23 AM


All times are GMT +1. The time now is 05:09 AM.

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"