Activate Workbook

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

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
 
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
 
Back
Top