MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Prevent worksheet/workbook from being copied

Posted by Loretta on January 27, 2002 3:00 PM

I know that I can protect the workbook and/or worksheet and no changes can be made to that, however, just because I have protected it doesn't mean that someone can't simply rename the file and make all the changes they desire. Is there a way to prevent this from happening? Any response would be appreciated.


Posted by Oberon on January 27, 2002 3:31 PM

If a worksheet/workbook is protected, copying or renaming does not unprotect it.

Posted by Loretta on January 27, 2002 6:19 PM


Posted by Fabian on January 27, 2002 7:02 PM

Do you mean that you are copying cells (not the sheet or the workbook) and pasting somewhere else?

Posted by Loretta on January 28, 2002 7:29 AM

No, I am copying the entire workbook or worksheet. My problem is that if I send out something I don't want to have changed (I have 9 Branches I work with)even though I can protect it they can copy and/or rename it and make any changes they wish. If you were to do this in Word the protection stays with the file. Why isn't this the same in Excel. HELP!!

Posted by Fabian on January 28, 2002 3:51 PM

I can't imagine what's wrong. Stays protected for me.