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/