activate workbook w/unknown name

G

Guest

Can I activate an open workbook without knowing name?

I have a macro that unprotects a workbook, copys and moves a worksheet,
activates the main workbook to re-protect it but I want to leave the user in
the new workbook. I don’t know if the name is Book2 or Book3, etc>

Sheets("Grid (2)").Move
ThisWorkbook.Activate
Sheets("Cover").Select
Range("C11").Select
ActiveWorkbook.Protect (["password"])
Now I want to activate the single sheet workbook that I moved (Book2 or Book3)
 
B

Bob Phillips

When you are in the new workbook, set a workbook object to it

Set oWB = ActiveWorkbook

You can always come back to it using that object variable
 
D

Dave Peterson

I like to use a range object and use that:

Dim CurRng as range

set currng = selection
'do lots of stuff
'now go back
application.goto currng



Jim said:
Can I activate an open workbook without knowing name?

I have a macro that unprotects a workbook, copys and moves a worksheet,
activates the main workbook to re-protect it but I want to leave the user in
the new workbook. I don’t know if the name is Book2 or Book3, etc>

Sheets("Grid (2)").Move
ThisWorkbook.Activate
Sheets("Cover").Select
Range("C11").Select
ActiveWorkbook.Protect (["password"])
Now I want to activate the single sheet workbook that I moved (Book2 or Book3)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can't seem to activate an open workbook 1
Create new workbook, temporarily name it and copy sheets to it 4
Excel - VBA - workbook/worksheet navigation 1
Run macro from active workbook whose name keeps changing 20
How to Activate Open Workbook 1
Macro to create a list 5
Need help to increment default WorkBook name in code 7
Excel VBA to go to specific sheet & cell in the current workbook not working. 2

Top