deter worksheet deletion
 

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...

deter worksheet deletion
 

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...

deter worksheet deletion
 

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...

deter worksheet deletion
 

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