Do not allow Copy/Paste Functionality in a Protected Sheet
 

Hi,

I have a Protected worksheet having 4 columns whe
1. Column A and B is Un-Protected and
2. Column C and D is Protected with Formulae.

However, in column A, I have "MM/DD/YY" Format and in Column B I have a
Drop-Down list.

I don't want to mess up my column A Format, since people can copy/paste
cells from column B or a different Format from another sheet into cells in
the Column A.

Please help me out to de-activate the Copy/Paste or Cut/Paste function so
that only Manual entry is possible in my Protected Sheet.

Your help will be greatly appreciated.

Thanks in advance,
Prashanth KR.

Do not allow Copy/Paste Functionality in a Protected Sheet
 

Have a look he http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Near the end of the page, they have detailed instructions how to make
it work if you are not familiar with VBA

Best,
www.exciter.gr
Custom excel applications and functions!




On Oct 29, 6:34 pm, Prashanth KR
wrote:
Hi,

I have a Protected worksheet having 4 columns whe
1. Column A and B is Un-Protected and
2. Column C and D is Protected with Formulae.

However, in column A, I have "MM/DD/YY" Format and in Column B I have a
Drop-Down list.

I don't want to mess up my column A Format, since people can copy/paste
cells from column B or a different Format from another sheet into cells in
the Column A.

Please help me out to de-activate the Copy/Paste or Cut/Paste function so
that only Manual entry is possible in my Protected Sheet.

Your help will be greatly appreciated.

Thanks in advance,
Prashanth KR.