Renaming a workbook and worksheet on clicking a button

[mohansingh]

Hi,

Please find attach sheet.

Demo.xlsm

I have a Demo sheet . In it i have "Main" workbook which contains a button as"Next Week" which when clicked will change the date in "abc" sheet cell C1 to next week date (i.e. from 14-June-2015 to selected date.)

I wanted the workbooks named "sheet1,sheet2... sheet7" to change name accordingly to what the date in respective c1,E1...O1

ie.
c1 value date will be sheet1 workbook name ie sheet1 will rename to 14-Jun-15
E1 value date will be sheet1 workbook name ie sheet1 will rename to 15-Jun-15
G1 value date will be sheet1 workbook name ie sheet1 will rename to 16-Jun-15, etc..

Additional thing - Renaming the same File/excel sheet to "ABC June 14 - June 20" where ABC is fixed value and June 14 comes from C1 and June 20 comes from O1.

Thanks in Advance .

Regards,
MS

[Kamboj]

here is the solution