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
|