Erase Code

You can write an if statement at the beginning of your
code to say something like:

If ActiveWorkbook.Name <> "YourWorkbookName.xls" Then
'Code Here
Else
'Other condition code here
End If

You can use = or <>.

This way when you change the name of the file, the code
will not run the next time because the workbook name has
changed. Im not sure if leaving this code in the workbook
is exactly what you want, but the reults will be to where
the code will not run.


Todd


>-----Original Message-----
>I have a spreadsheet that runs code when it opens to
populate the data. I
>need it to automatically erase the code once complete so
that when I save the
>workbook with a new name; the code does not rerun when
management opens the
>workbook to view the data.
>.
>

Would it be an option to have the code in another file and just manually
start running your program on the main file? or keep the code in the file,
but copy the resultant data over to a new file after your data processing
program completes?

"Todd Huttenstine" wrote:

> You can write an if statement at the beginning of your
> code to say something like:
>
> If ActiveWorkbook.Name <> "YourWorkbookName.xls" Then
> 'Code Here
> Else
> 'Other condition code here
> End If
>
> You can use = or <>.
>
> This way when you change the name of the file, the code
> will not run the next time because the workbook name has
> changed. Im not sure if leaving this code in the workbook
> is exactly what you want, but the reults will be to where
> the code will not run.
>
>
> Todd
>
>
> >-----Original Message-----
> >I have a spreadsheet that runs code when it opens to
> populate the data. I
> >need it to automatically erase the code once complete so
> that when I save the
> >workbook with a new name; the code does not rerun when
> management opens the
> >workbook to view the data.
> >.
> >
>