View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default copy cells but lock editing

If you lock the cells and protect the worksheet, what happens when the user
tries to copy those cells?

Lise wrote:

Hi everyone

I have a spreadsheet where I have locked cells and password protected.
within this sheet though I have not locked a specific range of cells as they
are used in another sheet as source data.

Is there a way that I can allow these cells to still be copied for the
source data but not actually changed by other users??
--
Thanks as always

Lise


--

Dave Peterson