| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two Sheets and copy value | Excel Worksheet Functions | |||
| Copy Sheets Macro | Excel Worksheet Functions | |||
| Copy and past to different sheets | Excel Discussion (Misc queries) | |||
| Copy Sheets | Excel Discussion (Misc queries) | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Linear Mode
