EXCEL - Disabling COPY function

This query is : Resolved

Anil (Querist)
Follow

23 March 2008

With protect sheet one can only stop someone from EDITing.

Can anyone please let me know how to disable 'Copy' function in EXCEL?

K V Subba Rao

K V Subba Rao (Expert)
Follow

23 March 2008 You can lock files and folders with folder lock to deny access to others

Anil

Anil (Querist)
Follow

23 March 2008 Others should be given access to view the file BUT not to COPY.

i.e,

CTRL+C function and the Copy Icon on the tool bars at the top - below the menu should not work when someone views the file.

How can one do that?

Upgrade to CAclubindia Pro. Subscribe Now!

Anil

Anil (Querist)
Follow

23 March 2008 Others should be given access to view the file BUT not to COPY.

i.e,

CTRL+C short cut key function and the Copy Icon on the tool bars at the top - below the menu should not work when someone views the file.

How can one do that?