![]() ![]() ![]() ' Changes cannot be undone, so save a copy 'Running the macro: The macro runs on the ActiveWorkbook. ' includes thumbnail image tiles of each sheet 'Description: Adds a new sheet with a Table of Contents that If bSkipHidden Or ws.Visible = xlSheetVisible Then 'Skipping hidden sheets can be toggled in the variable above Set wsTOC = Me 'can change to a worksheet ref if using in a regular code module ![]() 'Create Table of Contents on this TOC sheetĬonst bSkipHidden As Boolean = False 'Change this to True to NOT list hidden sheets 'Runs every time the sheet is activated by the user. You can create a sheet naming TOC to create the Table of Contents and copy the macro code below I find the macro code to meet your requirement. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |