Run a macro only once from a template...

[shajueasow]

Hi,
I have a template with some macros in it. Is it posibble to run an other macro, when template is opened as .xls for the first time. I just want to rename the sheets with dates of the month in which the file is opened. Is it possible?
TIA

 

[agihcam]

yes. you can see this in thisworkbook module.

Private Sub Workbook_Open()
   'your codes here
End Sub

 

[jindon]

You need to flag somehow if the sheet names has been updated or not.

eg.

If Sheet1.Name = "Sheet1" Then
'''' your code to change sheet names
End If

So that it will run only once

 

[shajueasow]

Thanks for both.
But agihcam, your method will always run the macro when the workbook is opened. But I need to run it only once, that is if the sheets are renamed then it shoud not run.
And jindon, that is a nice way that you have suggested. Thank You.
And thanks to agihcam too for sharing his idea.