MrSteve
04-22-2008, 07:06 AM
Hello
Does anyone know any VBA I can use to rename Sheet1 to the name of the Workbook when I save?
For example, I create a new workbook. I click File -> Save As -> And save it as "Hello.xls".
I would like Sheet1 in Hello.xls to automatically be renamed to Hello.
Is this possible?
Thank you!
Does anyone know any VBA I can use to rename Sheet1 to the name of the Workbook when I save?
For example, I create a new workbook. I click File -> Save As -> And save it as "Hello.xls".
I would like Sheet1 in Hello.xls to automatically be renamed to Hello.
Is this possible?
Thank you!