View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default How to hide a workbook using VBA

use
workbooks(wrkbkref).activate
ActiveWindow.Visible = False


"Jeff" wrote:

I am trying to open a workbook, manipulate it, copy several sheets to another
workbook and then close the opened workbook.

I am using ".Workbooks(WrkBkRef).Visible = False" but nothing happens. The
variable "(WrkBkRef)." works fine for other operations so I know its not that

Any Ideas