LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default automatically locked cells

How I can prevent my linking from one Excel file to another Excel file from
being locked? If I make one cell on file one = to a cell on file two then
it automatically adds the $ to lock the cells. I have to go into each cell
and remove it to fill by dragging. i don't want this. If I can't prevent it,
can I remove them in a bulk way instead of having to go into each cell to
remove the "$"?
 
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
Locked worksheet & hyperlinks (w/ select locked cells unchecked) dgold82 Excel Discussion (Misc queries) 1 July 10th 09 09:42 PM
CELLS TO BE AUTOMATICALLY LOCKED FARAZ QURESHI Excel Discussion (Misc queries) 1 December 3rd 07 12:27 PM
paste locked cells and unlocked cells in protected sheet Angeline Excel Worksheet Functions 15 November 1st 06 11:51 PM
Put comments on a locked spreadsheet even though cells not locked RDP Excel Worksheet Functions 1 September 11th 05 11:59 PM
Locked cells Pam Coleman Excel Worksheet Functions 1 November 18th 04 02:45 PM


All times are GMT +1. The time now is 11:56 PM.

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

About Us

"It's about Microsoft Excel"