Hide All Worksheets Except Active One

Sometimes, you may need to hide all Worksheets except active one, if the Workbook have many Worksheets, it seems very boring to […]

Delete All Worksheets Except Active One

Sometimes, you may want to delete all Worksheets except the active one, if the Workbook have many Worksheets, it seems very boring […]

Refresh All Data Connections on Workbook Open

Your workbook may have connections to external data sources such as web queries, MSQuery connections, PivotTable connections, and so on. In these […]