Hiding active workbook programmatically in Excel

by

Hiding the active workbook is possible with

ActiveWorkbook.Windows(1).Visible = False

You may need to replace ActiveWorkbook with an appropriate reference if the workbook in question is not the active one and/or add a loop like For i = 1 To ActiveWorkbook.Windows.Count if the workbook has multiple windows.

More Related Contents:

  1. Loop through files in a folder using VBA?
  2. Run same excel macro on multiple excel files
  3. how to detect whether VBA excel found something?
  4. VBA : save a file with UTF-8 without BOM
  5. Excel tab sheet names vs. Visual Basic sheet names
  6. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  7. Determine if cell contains data validation
  8. VBA – Range to jpg picture
  9. Sheet protection: UserInterFaceOnly gone
  10. VBScript – How to make program wait until process has finished?
  11. Making VBA Form TextBox accept Numbers only (including +, – and .)
  12. VBA Convert date to week number
  13. Inserting an Online Picture to Excel with VBA
  14. Change length of For loop while in the loop
  15. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  16. Consolidating worksheets into one
  17. Copy filtered data to another sheet using VBA
  18. TextJoin UDF For Excel 2013
  19. Open an Excel file from SharePoint site
  20. How to get address of cell which calls a VBA Functions in a Excel sheet
  21. Add new row to excel Table (VBA)
  22. How do I open a file if I only know part of the file name?
  23. VBA recognizing workbook by partial name
  24. Calling regasm without administrative rights for COM interop in Excel VBA
  25. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  26. How do I activate a specific workbook and a specific sheet?
  27. Start VBA macro when editing a cell
  28. VBA Run-time error 438 appears when “paste” runs
  29. If Not function proceeds when value *is* the one specified
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment