View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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