Home |
Search |
Today's Posts |
#1
|
|||
|
|||
activate workbook w/unknown name
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 dont 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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
Activate a workbook from a selection | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |