View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Copying cells in a protected worksheet

If you copy and paste into just the unprotected ranges, you should be ok.

Rohit wrote:

Hi,
I have a worksheet in which few of the columns are protected whereas others
are unprotected. these protected columns are in between unprotected columns.
I would like to copy data from an external souce to this worksheet without
unprotecting the sheet. Is it possible.

Thanks in advance


--

Dave Peterson