Excel - Copying locked cells into unlocked cells

[Atrain18wi]

I am looking for a way to lock formulas within certain columns of a spreadsheet. If I lock the indivual columns and protect the sheet I cannot copy and paste additioanl rows since the columns are locked.

If I only lock the desired cells then when I copy the necessary rows into unlocked cells the pasted cells become unlocked.

Is there a way to copy locked cells into unlocked cells which will keep the locked status?

Thanks

 

[SkipVought]

Hi,

Not without VBA code.

Skip,

_[red][/red]

 

[Atrain18wi]

Too Bad, Thanks

 

[SkipVought]

I notice that you posted a different question in the VBA forum. Do you not want to use VBA?

Basically, the code process would be...
[tt]
Unprotect the sheet
Do stuff to the contents of the sheet
Protect the sheet
[/tt]


Skip,

_[red][/red]

 

[Atrain18wi]

Not in this case because this spreadsheet will have multiple users of which some who are deathly afraid of a macro and have trouble just copying and pasting cells.

Thanks

 

[SkipVought]

Huh? Disaster!

Skip,

_[red][/red]

 

[Rofeu]

Hi,

just use the change event to fire off your code and the user will never know something besides a copy and paste happened.

Cheers,

Roel