EXCEL
Batch Export Visible Excel Sheets to PDF using VBA
A simple VBA utility to export every visible worksheet as a separate PDF file inside a PDF_Exports folder next to the workbook.
#vba
Posts
Clear Filter
EXCEL
Create an Excel Sheet Index with Hyperlinks using VBA
A clean VBA module to generate an _Index sheet with hyperlinks to all visible sheets in a workbook.
EXCEL
Excel VBA Scanner for Broken External Links and Chart References
A ready VBA scanner that lists external workbook links from cells, defined names, charts, connections, pivot caches, validation, and conditional formatting without asking Excel to open missing source files.