It doesn't quite work. May be I can explain in more detail
I have 3 sheets in a workbook that are used as input sheet.
1. Users can not insert a new sheet (which is taken care with the Private Sub)
2. Users are NOT ALLOWED to delete any of sheets contained in the report
but ALLOWED to change the names any of the 3 sheets in the workbook.
(this, #2, is the one I need your help)
THANK YOU! JP77