How to hide a workbook using VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Save As and new workbook new name used in existing code 8
vba code does not run 3
VBA Debug Issue 2
Addin not allowing thisworkbook.save in before save event 3
Copying cells and formula from closed workbook to all sheets in open workbook 0
How to append data from different sheet and different workbook? 2

Back
Top