Hi,
is there any way I can prevent user from deleting specific sheet yet let him
being able to insert sheets and delete them?
Thanx

alek_mil

You could protect the workbook (tools|Protection|Protect workbook) to stop the
user from insert/deleting/moving/renaming sheets.

But then you'd have to supply some other way (a couple of macros that only allow
the user to do what you want them to do???).

Your macros would
get the info
unprotect the workbook
do the work
reprotect the workbook

And just to add, workbook protection is easily broken. It won't stop any
dedicated person from removing the password and just doing what they want.

alekm wrote:

Hi,
is there any way I can prevent user from deleting specific sheet yet let him
being able to insert sheets and delete them?
Thanx

alek_mil

--

Dave Peterson