Change Name on Worksheet Tab
 

Hello,
Is there a way to know if a worksheet name is changed? Or to prevent a
change without protecting the workbook?

Thanks,

Bill

Change Name on Worksheet Tab
 

Bill

If you are worried about users changing the tab name and you code failing,
change the codename in design view. This is not effected by the
worksheet(x).name or tab name so will be fine, you refer to the codename
like Sheet1.Range("A1")

You could otherwise possibly use a workbook event but none would be 100%
accurate I fear

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Bill" wrote in message
nk.net...
Hello,
Is there a way to know if a worksheet name is changed? Or to prevent a
change without protecting the workbook?

Thanks,

Bill