You can change the visibility of the other workbooks. You set the workbook
and then make it invisible:
Set oWorkbook = Application.Workbooks("My_Workbook_Name")
Application.Windows(oWorkbook.Name).Visible = False
--
Robert
Author of RibbonX: Customizing the Office 2007 Ribbon:
LATEST INTERACTIVE TUTORIAL:
http://www.msofficegurus.com/videos/...p_HT_Chart.asp
FORUM:
http://www.msofficegurus.com/forum/