Do not allow Copy/Paste Functionality in a Protected Sheet

G

Guest

Hi,

I have a Protected worksheet having 4 columns where:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top