Not Being Able to copy sheets
 

I have a workbook I have creatred, it has 30 sheets, I have it protected, but
I also want to be able to lock the out people from bering able to copy any of
the sheets or add sheets. Can anyone suggest how I can do that? Please need
help ASAP

Thanks,

Not Being Able to copy sheets
 

ToolsProtectionProtect Workbook for Structure and Windows will prevent
copying/moving/inserting a sheet.

But that won't stop anyone from copying the data and pasting to a new sheet in
another workbook.


Gord Dibben MS Excel MVP


On Wed, 12 Sep 2007 06:40:01 -0700, JackR
wrote:

I have a workbook I have creatred, it has 30 sheets, I have it protected, but
I also want to be able to lock the out people from bering able to copy any of
the sheets or add sheets. Can anyone suggest how I can do that? Please need
help ASAP

Thanks,