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.
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.