Vba Hide Workbook While Macro Is Running. When I refresh a sequence of queries via a macro I'd like to see which ones are running. Visible VBA to show the query pane.
Instead of identifying the destination workbook by name, you can use the ThisWorkbook property. You may do better in one of the Excel or VBA forums. Screenupdating = False) so initially the screen stays focused on the original workbook.
You may do better in one of the Excel or VBA forums.
A common practice of many VBA developers is to restrict access in the code that they don't want the users to "see" in the Macros menu of Excel (i.e. they create Use the Application.
Microsoft ISV Community Center. > Visual Basic for Applications (VBA). The only way to see that the Worksheet exists (or unhide the Worksheet) is by opening the Visual Basic. Your macro can access any cells in the workbook, unless the worksheet containing the cell is The upshot of this is that if you want to run a macro and have it access information on a hidden worksheet, you must first "unhide" the worksheet.