Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Workbook | Excel Discussion (Misc queries) | |||
I cant hide a workbook | Excel Worksheet Functions | |||
How to hide a workbook and to detect a hidden workbook in visual basic | Excel Programming | |||
Hide a workbook | Excel Programming | |||
Hide workbook | Excel Programming |