I have a worksheet that contains a "scorecard" (cells C5:W29) and 11 charts that are centered below the scorecard one by one.
Chart 1 is row 32 through row 67
Chart 2 is row 68 through row 102
Chart 3 is row 103 through row 137
Chart 4 is row 138 through row 172
Chart 5 is row 173 through row 207
Chart 6 is row 208 through row 244
Chart 7 is row 245 through row 281
Chart 8 is row 282 through row 318
Chart 9 is row 319 through row 356
Chart 10 is row 366 through row 393
Chart 11 is row 394 through row 429
I am needing a macro that will display a selection box where I can check which of the charts and scorecard I want to print. (i.e One person might want to print Charts 1 and 2 and another person might want to print the scorecard plus Charts 1, 5, 6, 7, etc.) I have a button on my worksheet now called "Print Scorecard & Charts" that I was planning to use to excute the macro. Each chart/ scorecard would need to be on it's own 11x17 page.
I am brand new to VBA and any help would be greatly appreciated!
John
Chart 1 is row 32 through row 67
Chart 2 is row 68 through row 102
Chart 3 is row 103 through row 137
Chart 4 is row 138 through row 172
Chart 5 is row 173 through row 207
Chart 6 is row 208 through row 244
Chart 7 is row 245 through row 281
Chart 8 is row 282 through row 318
Chart 9 is row 319 through row 356
Chart 10 is row 366 through row 393
Chart 11 is row 394 through row 429
I am needing a macro that will display a selection box where I can check which of the charts and scorecard I want to print. (i.e One person might want to print Charts 1 and 2 and another person might want to print the scorecard plus Charts 1, 5, 6, 7, etc.) I have a button on my worksheet now called "Print Scorecard & Charts" that I was planning to use to excute the macro. Each chart/ scorecard would need to be on it's own 11x17 page.
I am brand new to VBA and any help would be greatly appreciated!
John
