Fred,

The ThisWorkbook reference will always refer to the workbook
containing the code. So you can write

ThisWorkbook.Activate


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Fred" wrote in message
...
I've written some code that will be used in a workbook
template. The code creates a new workbook, does some
stuff to it, closes it, and returns to the template. I
was using the following code:

Windows("Template.xls").Activate

But, I've realized that the users will probably be
changing the name of the workbook. How can I always return
to the workbook in which the macro resides?

Thanks in advance!
Fred