workbooks(2).activate

[lezawang]

Hello

I wrote the code below to activate the second workbook. The code below is work if both workbooks 1, 2 are opened. I minimized workbooks(2) (put it in taskbar) and ran the code below, excel did not try to open workbooks(2)? It did stay in task bar (not opened), why is that? Thank you.

'dealing with workbooks(1)object
Sub mywb1()
  'properties
  MsgBox (Application.Workbooks(1).Name)
  'methods
  Workbooks(2).Activate
End Sub

 

[daverunt]

Hi,

I don't know if this works but give it a shot.
https://groups.google.com/forum/#!topic/microsoft.public.excel/fHZkeuy8vQo
http://www.java2s.com/Code/VBA-Excel-Access-Word/Excel/maximizesanyworkbookwhenitisactivated.htm

 

[Yongle]

Simple workaround
- use {TAB} to move between windows
- do not minimize

Workaround 2 (it works for me)
- maximise all window with {WIndows Key} + {SHIFT} + M
- run your macro

To fully automate requires using API
- put this into Google excel vba "sendkeys" "Windows key" shift m