VBA to only execute an action once

[canthony24]

How do I tell the VBA code to stop a particular action once it has been executed? I have my one of my macros copy an existing worksheet, then it hides it. But once I click the button to execute the macro again, it creates another copy of the worksheet. I only want it to create the copy of worksheet once, then hide it.

Basically, if the new copy is named "Source Data_Post", don't copy the original once the macro is executed again.

Ideas?

Here is the code I have for what I am asking about:

Sheets("Source Data").Select
Sheets("Source Data").Copy After:=Sheets(1)
Sheets("Source Data (2)").Select
Sheets("Source Data (2)").Name = "Source Data_Post"
Sheets("Source Data_Post").Select
ActiveWindow.SelectedSheets.Visible = False

 

[ranman256]

i = sheets.count + 1
vName = "Source" & i
activesheet.name = vName
activesheet.Copy before:=Sheets(1)
sheets(1).name = "Source Data"


Sheets(vName).Select
ActiveWindow.SelectedSheets.Visible = False