thanks for your answer.
1."The EnableSelection property has to be set each time the workbook is
opened as it does not persist across the closing and opening of a workbook".
but why. is it a problem,or it is set to be so.
2.i don't want to protect my sheet with a macro,for it can be disable easily
when the file is opened.

thank you.




"Tom Ogilvy" wrote in message
...
Activesheet.Protect Password:="ABCD:
ActiveSheet.EnableSelection = xlNoSelection

The EnableSelection property has to be set each time the workbook is
opened
as it does not persist across the closing and opening of a workbook. You
might set it in the workbook_Open event or worksheet_Activate event or
both.

--
Regards,
Tom Ogilvy

"youngman" wrote in message
...
hi,
i d like to protect my sheets.
i know there are many methods to do it,but i just want to do by setting

the property of the sheet to be -4142-xlnoselection.

but it comes to be of no result.

what is the problem.

thank you.