Set a reference to the workbook when you create it. In a general Module.

Public NewBook as Workbook

Public sub OpenBook()
Set NewBook = Workbooks.Add
End Sub

Public Sub ActivateBook()
NewBook.Activate
End Sub



"cornishbloke" wrote in message
...
Hopefully this is a simple question that I can't find the answer for
elsewhere...

in VBA, how do I activate the most recent new worksheet?

I have a macro which opens a new workbook and then later needs to
activate this window. Having recorded this using the macro recorder
the code is static (e.g. refers to "book1") and won't work again unless
I manually change these values to the next new workbook name.

Thanks in Advance.


---
Message posted from http://www.ExcelForum.com/