Protecting the structure of the workbook would prevent both. So not the
singular solution.

Think you would have to protect the structure then provide your own
programmed interface for adding a sheet.

--
Regards,
Tom Ogilvy



"flintridge parkenfarker vonkerschnauzerh" wrote:

> Hello,
>
> It's been over 5 yrs since I've been to a newsgroup for Excel and I used to
> practically live here. Taught me how to program. (blah, blah--with a tear in
> my eye :-) ).
>
> Oh geez, who's that guy? The Excel king? John Walkenbach!!! Was my hero! No
> kidding, he used to do some really cool stuff. I didn't have to shower,
> cook, or... well... anything else thanks to John. I should stop by his site
> again for old time's sake.
>
> I'm sorry. I can't help it. It's been so long and so much has happened...
> (sniff, sniff); however ! (clear my throat), back to biz...
>
> OK, there's a guy at work that refuses to follow instructions. Rather than
> simply click-n-drag a worksheet from one book to another, he feels the need
> to follow some other process--I suppose one in which he deletes the given
> sheet, creates a new one, then copies and pastes the data from one book to
> another. I know, I don't understand either; but I keep track of the errors
> and his are always "sheet missing" in a Read Only book that is already setup
> with everything he needs.
>
> I've tried everything I can think of to discourage this behavior because his
> savvy is outweighed by his arrogance/ignorance and I'm tired of re-doing his
> work. No one has the problem but him.
>
> Is there some way to discourage someone from deleting a worksheet from a
> workbook in Excel 2000, but still allow them to ADD a worksheet to the
> workbook?
>
> I'd appreciate any insights from you masters.
>
> Thank you,
>
> (geez, I'm not even sure who I am here) Oh... oooooooo... seriously, it's
> been so long.
>
> Just call me: fpv
>
> I'd appreciate your help folks... very much.
>
> Catch ya later...
>
>
>

Protecting the structure of the workbook would prevent both. So not the
singular solution.

Think you would have to protect the structure then provide your own
programmed interface for adding a sheet.

--
Regards,
Tom Ogilvy


"flintridge parkenfarker vonkerschnauzerh" wrote:

> Hello,
>
> It's been over 5 yrs since I've been to a newsgroup for Excel and I used to
> practically live here. Taught me how to program. (blah, blah--with a tear in
> my eye :-) ).
>
> Oh geez, who's that guy? The Excel king? John Walkenbach!!! Was my hero! No
> kidding, he used to do some really cool stuff. I didn't have to shower,
> cook, or... well... anything else thanks to John. I should stop by his site
> again for old time's sake.
>
> I'm sorry. I can't help it. It's been so long and so much has happened...
> (sniff, sniff); however ! (clear my throat), back to biz...
>
> OK, there's a guy at work that refuses to follow instructions. Rather than
> simply click-n-drag a worksheet from one book to another, he feels the need
> to follow some other process--I suppose one in which he deletes the given
> sheet, creates a new one, then copies and pastes the data from one book to
> another. I know, I don't understand either; but I keep track of the errors
> and his are always "sheet missing" in a Read Only book that is already setup
> with everything he needs.
>
> I've tried everything I can think of to discourage this behavior because his
> savvy is outweighed by his arrogance/ignorance and I'm tired of re-doing his
> work. No one has the problem but him.
>
> Is there some way to discourage someone from deleting a worksheet from a
> workbook in Excel 2000, but still allow them to ADD a worksheet to the
> workbook?
>
> I'd appreciate any insights from you masters.
>
> Thank you,
>
> (geez, I'm not even sure who I am here) Oh... oooooooo... seriously, it's
> been so long.
>
> Just call me: fpv
>
> I'd appreciate your help folks... very much.
>
> Catch ya later...
>
>
>

Hello,

It's been over 5 yrs since I've been to a newsgroup for Excel and I used to
practically live here. Taught me how to program. (blah, blah--with a tear in
my eye :-) ).

Oh geez, who's that guy? The Excel king? John Walkenbach!!! Was my hero! No
kidding, he used to do some really cool stuff. I didn't have to shower,
cook, or... well... anything else thanks to John. I should stop by his site
again for old time's sake.

I'm sorry. I can't help it. It's been so long and so much has happened...
(sniff, sniff); however ! (clear my throat), back to biz...

OK, there's a guy at work that refuses to follow instructions. Rather than
simply click-n-drag a worksheet from one book to another, he feels the need
to follow some other process--I suppose one in which he deletes the given
sheet, creates a new one, then copies and pastes the data from one book to
another. I know, I don't understand either; but I keep track of the errors
and his are always "sheet missing" in a Read Only book that is already setup
with everything he needs.

I've tried everything I can think of to discourage this behavior because his
savvy is outweighed by his arrogance/ignorance and I'm tired of re-doing his
work. No one has the problem but him.

Is there some way to discourage someone from deleting a worksheet from a
workbook in Excel 2000, but still allow them to ADD a worksheet to the
workbook?

I'd appreciate any insights from you masters.

Thank you,

(geez, I'm not even sure who I am here) Oh... oooooooo... seriously, it's
been so long.

Just call me: fpv

I'd appreciate your help folks... very much.

Catch ya later...

> It's been over 5 yrs since I've been to a newsgroup for Excel and I used to
> practically live here. Taught me how to program. (blah, blah--with a tear in
> my eye :-) ).

Hey, just like me. I used to come to these groups several times a day.


> Oh geez, who's that guy? The Excel king? JohnWalkenbach!!! Was my hero! No
> kidding, he used to do some really cool stuff. I didn't have to shower,
> cook, or... well... anything else thanks to John. I should stop by his site
> again for old time's sake.

Yeah, do stop by. It will look exactly as you remember it.

-John Walkenbach
www.j-walk.com/ss