Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent Tab from User Delete
Hello All:
when I use the protect sheet function it prevents the users to do just abt any modification to data and or content to include formatting and all which is a great function, how ever I need to stop users from either deleting the tab or copying it(i.e the right click - delete, re- name, move or copy) is there any way we can disable this in a worksheet........ Ardy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent Tab from User Delete
Protect the Workbook structure to prevent sheet deletions, moving or
renaming. But this won't prevent copying selectable cells and pasting to a new workbook. Under sheet protection you can make all cells unselectable. But this won't prevent users from opening a new workbook and linking to your sheet and workbook. Gord Dibben MS Excel MVP On Tue, 8 Sep 2009 14:57:19 -0700 (PDT), Ardy wrote: Hello All: when I use the protect sheet function it prevents the users to do just abt any modification to data and or content to include formatting and all which is a great function, how ever I need to stop users from either deleting the tab or copying it(i.e the right click - delete, re- name, move or copy) is there any way we can disable this in a worksheet........ Ardy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent Tab from User Delete
On Sep 8, 3:36*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Protect the Workbook structure to prevent sheet deletions, moving or renaming. But this won't prevent copying selectable cells and pasting to a new workbook. Under sheet protection you can make all cells unselectable. But this won't prevent users from opening a new workbook and linking to your sheet and workbook. Gord Dibben *MS Excel MVP On Tue, 8 Sep 2009 14:57:19 -0700 (PDT), Ardy wrote: Hello All: when I use the protect sheet function it prevents the users to do just abt any modification to data and or content to include formatting and all which is a great function, *how ever I need to stop users from either deleting the tab or copying it(i.e the right click - delete, re- name, move or copy) is there any way we can disable this in a worksheet........ Ardy Thanks. Maybe there is a way from the VB side. should I post this in that group. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prevent a user from entering data in a cell? | Excel Discussion (Misc queries) | |||
Prevent user from using Name | Excel Discussion (Misc queries) | |||
prevent user to delete specific sheets | Excel Discussion (Misc queries) | |||
Prevent user from saving workbook | Excel Discussion (Misc queries) | |||
How to prevent user from printing in Excel? | Excel Discussion (Misc queries) |