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.
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.