Eurekaonide
Active Member
- Joined
- Feb 1, 2010
- Messages
- 433
Hi All
I have some code which brings the Active workbook back into focus using coed
But if I have set at the top the following;
can I somehow alter the first set of code the Windows.Activate to call the WB ?
I tried Windows("WB").Activate and Windows."WB".Activate
but neither worked any suggestions?
I have some code which brings the Active workbook back into focus using coed
HTML:
Windows("Project Workbook Template V6.5.xls").Activate
But if I have set at the top the following;
HTML:
Dim WB As Excel.Workbook
Set WB = ThisWorkbook
can I somehow alter the first set of code the Windows.Activate to call the WB ?
I tried Windows("WB").Activate and Windows."WB".Activate
but neither worked any suggestions?