Five-Weeks.xls

<div>
AWESOME!!<br />
<br />
Thank you Brian!
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts.<br />
<br />
I have my auto_open routine set - but I want to add additional code to ensure that my sheet names were not changed by an enduser. &nbsp;If they were changed - then I want to reset them back to their original name on open. &nbsp;I do not have the workbook protected, just the individual sheets.<br />
<br />
I have 5 worksheets where the name should stay the same. &nbsp;(The code.names are no longer sheet1 sheet 2) The code.names are set as follows:<br />
<br />
week1, week2, week3, week4 &amp;&nbsp;week5<br />
<br />
In my open routine - I want to rename any worksheet that may have been changed by referencing it by it's codename. Listed below are the code.name with the respective worksheet names.<br />
<br />
week1 = &quot;week 1&quot;<br />
week2 = &quot;week 2&quot;<br />
etc. etc.<br />
<br />
Is this possible to do this?<br />
Thank you,<br />
Michael
</div>
</div>


Hello Experts.

I have my auto_open routine set - but I want to add additional code to ensure that my sheet names were not changed by an enduser.  If they were changed - then I want to reset them back to their original name on open.  I do not have the workbook protected, just the individual sheets.

I have 5 worksheets where the name should stay the same.  (The code.names are no longer sheet1 sheet 2) The code.names are set as follows:

week1, week2, week3, week4 & week5

In my open routine - I want to rename any worksheet that may have been changed by referencing it by it's codename. Listed below are the code.name with the respective worksheet names.

week1 = "week 1"
week2 = "week 2"
etc. etc.

Is this possible to do this?
Thank you,
Michael

Excel VBA set sheet name at auto_open routine

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.