How to hide a workbook using VBA
Read and consider your error messages. The error says "object doesn't
support this property or method" ? It's telling me that Visible is not an
option for a Workbook.
From there, search Help on Visible. It has an "applies to" list and you
whould find something useful there (hint: its "W" section).
HTH. Best wishes Harald
"Jeff" skrev i melding
...
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
|