Protecion

  • Thread starter Thread starter Charlie Goodman
  • Start date Start date
C

Charlie Goodman

I create forms for people to use at work. I protect both
worksheets and workbooks. I use office 2002--fine, no
one can make changes etc. but if file is used with office
2000, people can copy and paste entire document and then
they take the credit for creating form. How can I keep
the copy and paste option from working? Or how can I
prevent the above mentioned?
 
There's not much you can do within excel.

Maybe print the form and show it to your boss--so that he/she knows who really
did it.

Maybe you could put some text in an out of the way cell. (Copyright Goodman,
2004)

Then format it with a custom format: ;;;

The cell will look empty. If the "borrower" doesn't notice, you can ask later,
"Hey what's this in cell X28?"

But since you're working for(?) the same company, maybe it's better to take one
for the team. Tell them that if they want to use it for a template for future
work to come and see you and you'll provide an unprotected version.

(Someday, they'll visit this newsgroup and ask how to unprotect the worksheet
and workbook and you'll be more stuck.)
 
I was wondering if there is a way that I can protect an Excel worksheet that I gave acess to from copying or paste to another worksheet or disk....please help
 
Excel isn't made for that kind of protection. If you have stuff you don't want
shared, don't use excel.
 
Back
Top