tags:

views:

118

answers:

1

Hello, I have an Excel sheet which is protected and a few contiguous cells which are editable. Is there a way I can allow a user to copy paste data into these cells, but the user should not be able to type in values directly into these cells? I am willing to accept a solution using VBA too.

Thanks in advance.

Regards, Anindya

+1  A: 

Lock up all the cells so they can neither type nor copy into those cells.

You can ask the user to copy the cells they want.

Put a button on the Excel sheet that says "Paste details". When the click the buttton, use VBA code to paste the details at the specific cell range that you want.

Raj More