I’m looking for assistance with coding an Excel document and wanted to check if this is something you can help with.
Part 1:
The workbook currently has around 60 tabs. I would like Tab 1 (Page 1) to act as a control page containing a series of checkboxes, each linked to one of the tabs. From Tab 1, the user would select the required tabs (for example: tabs 1, 9, 23, 45, 68). Once selected, clicking a button would generate a PDF containing only the chosen tabs.
To make this easier, I do have another Excel document that already works in this way. While the structure of the two documents is different (so the code can’t simply be copied and pasted), the existing file could be used as a reference for the logic and approach.
Part 2:
Also on Tab 1 (Page 1), I’d like the user to be able to choose an output format (for example: Format A, Format B, Format C). Depending on the selected format, the PDF output would change its appearance.
For example:
Format A: Selected tabs exported with a blue heading
Format B: Selected tabs exported with no headings
Format C: Selected tabs exported with a green heading and green footer
The format selection would apply to the same tab-selection logic described in Part 1.
Please let me know if this is something you can assist with, and if you’d like me to share the reference document for review.
... Show more