I don't see a way in VBA, but you might look at some utilities that
may do it:

Planetscott 1.0
www.download.com/.../3000-2347_4-5382398.html
3
Actual window  Manager
http://www.actualtools.com/windowmanager/
Absolute Way Tweak Window
www.absoluteway.com/.../overview.htm?ad_topmost
SemTop! 2.0
http://www.softcities.com/SemTop!/download/12025.htm

I haven't tried them, let us know if you do!