I am trying to come up with the best way to do this and figured there was no better place to get some ideas than here.
I have a workbook with 15 or so worksheets. On the main sheet, where most data is inputed, I have a button that will run a print macro. I would like for the user to have a choice of which worksheets to print when they click the button. What would be the best way to do this? Can a form pop-up? I am not too familiar with the VBA behind it either, but am willing to try the best solution regardless of the the code involved. Thanks in advance,
Mark
I have a workbook with 15 or so worksheets. On the main sheet, where most data is inputed, I have a button that will run a print macro. I would like for the user to have a choice of which worksheets to print when they click the button. What would be the best way to do this? Can a form pop-up? I am not too familiar with the VBA behind it either, but am willing to try the best solution regardless of the the code involved. Thanks in advance,
Mark