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

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