View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alfred Alfred is offline
external usenet poster
 
Posts: 3
Default Pasting into protected cells

Is it possible to "protect" cells in a row such that when you are
pasting a group of cells into that row, the protected cells are
skipped over?

Example:

I want to paste this:
Columns
A B C
d1 d2 d3

into this:
Columns
A B C
p

p="protected" cell


so it looks like this:
Columns
A B C
d1 p d3


Is this possible with Excel as it is? With a script or macro?

Thanks!