Protecting Sheet Names
There is an Excel file that teaches how to perform the Protecting Sheet Names operation.
Excel Source: Protecting Sheet Names
This workbook prevents sheet renaming using VBA event handlers across two named sheets.
Hope it is useful.
ADVERTISEMENT AREA