Copy Paste Help

Hi Everybody,

I am looking for an assistance in an excel file, i should allow the user to copy the contents of columns B to G only and others column contents should not be copied at all.

Thanks,
Hariharan R

Adding to the previous post, I have also protected the sheet by giving access to work in all the columns by unlocking and protecting the sheet. Only certain columns are blocked from use.

Hi,

Thank you for the quick response. I am aware of this part, but let me tell you the real usage behind. I have created an excel file in which through the VBA coding I have completely deactivated the copy and paste in the entire workbook, even right click has also been deactivated.

Now I am looking for an excel vba solution which will help me to allow the user to copy and paste only the columns B to G other columns should not be permitted.

Hope you are able to understand my real time issue here..

Regards,
Hariharan R