karl_burns
New Member
- Joined
- Jul 10, 2007
- Messages
- 19
I have a workbook with 23 pages, each pages having a macro to determine the final answer.
I would like to make a table of contents that when executed, creates a dialog box listing the 21 pages (with a default "check" in the box as instructions to run the macro on that page) asking the user which of the 21 macros should be executed.
I would like to perform this action as a dialog box in lieu of making it from an additional excel sheet.
Anyone know how to do this?
Thanks in advance,
Karl
I would like to make a table of contents that when executed, creates a dialog box listing the 21 pages (with a default "check" in the box as instructions to run the macro on that page) asking the user which of the 21 macros should be executed.
I would like to perform this action as a dialog box in lieu of making it from an additional excel sheet.
Anyone know how to do this?
Thanks in advance,
Karl