Prevent a tab from edit, delete and copy

[Ardy]

Hello All:
I posted this into MS-Excel Functions and didn't get the results. it
seem the inherit functions built in will let you do either or. So I
am wondering if there is VB Solution to this.
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

 

[Gord Dibben]

I replied yesterday to this post in excel.functions

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.

Did you see it and decide that it wasn't what you wanted to hear?


Gord Dibben MS Excel MVP

 

[ardy]

I replied yesterday to this post in excel.functions

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.

Did you see it and decide that it wasn't what you wanted to hear?

Gord Dibben  MS Excel MVP

Yes I did see it and replied. maybe this is a confusion on my part.
there are two particular groups that I was looking at 1)
microsoft.public.excel.worksheet.functions
2)microsoft.public.excel.programming, my first post was to the
worksheet functions, I thought there might be a VB solution to this,
that is why I posted it under the second one programing, not
realizing that essentially they are he same.

Sorry for the confusion........

 

[Gord Dibben]

Aplogies Ardy

I did not get to your reply to me yesterday in excel.functions before
sending the posting.

I don't think you will get any VBA method but there are some pretty
knowledgeable people hanging out in programming group.


Gord

 

[ardy]

Aplogies Ardy

I did not get to your reply to me yesterday in excel.functions before
sending the posting.

I don't think you will get any VBA method but there are some pretty
knowledgeable people hanging out in programming group.

Gord

No worry, it happens to the best of us.....I just hope there is
programer viz out there that can show me the way........