Tab Rename Routine

[dwgnome]

I have an existing workbook with worksheet names such as 01, 02, 03 through 31. At the end I have worksheet names in this order: JUL 10SUM, JUL 10H, JUL 10S, JUL 10O and JUL 10R<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
On worksheet 01 I have user input cells for the date with the month, day, year in separate cells. For example in cell $C$58 has the text July, $D$58 as number, and $E$58 the year like 2010 as a number.<o></o>
<o></o>
Can someone provide/show a code that can rename the worksheet names described above to match the Month and Year?<o></o>
<o></o>
For example, if the date in worksheet 01 is November 15, 2011, then the worksheet names should be NOV 11SUM, NOV 11H, NOV 11S etc. This would need to be done automatically without user involvement other than changing the Month, Day and Year.<o></o>

 

[dwgnome]

Thank you ever so much. It works like a charm.

As for the macro warning, I have Excel 2003 and don't see the Excel Options/Trust Center....

I can get to Options, Security dialog and pressed Macro Security.
Then security level choices very high, high, medium (which is what I have) and low.

When I go to Trusted Publishers tab, the box has headings like Issued to, issued by and expires. Below it has checked Trust all installed add-ins and templates and also checked is Trust access to Visual Basic Project. Yet I do not see a way to enter anything.

I can switch to Low security and the macro warning no longer pops up when I open the workbook, but I think a better situation is to figure out how to allow the module you made to be trusted. Is there a way to do that?

 

[Ruddles]

Not as far as I'm aware, but I'll be the first to admit glaring gaps in my Excel-ise.

Anyone?

(If no-one responds you might try starting a new thread.)

 

[dwgnome]

Again thank you for sharing your knowledge.

I'll await for other input for now.

 

[VoG]

This may help http://www.mrexcel.com/forum/showthread.php?t=110793

 

[dwgnome]

Thanks VOG, I will look into it and get back.