| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook name
I need to activate one or other windows by switching from one to the other
rather than by name of sheet: Windows("DoorSchedule.xls:1").Activate Windows("DoorSchedule.xls:2").Activate but this does not work if the Workbook is renamed. Please show me how to write something like: Windows(Workbook.name + ".xls:1").Activate Thanks Francis Hookham |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
Threaded Mode
