Prevent Tab from User Delete

  • Thread starter Thread starter Ardy
  • Start date Start date
A

Ardy

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
 
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
 
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
Click to expand...

Thanks.
Maybe there is a way from the VB side. should I post this in that
group.
 
Back
Top