polarisking
Member
I have a number of stand-alone macros that I run against worksheets in other open workbooks. Let's say my macro workbook is Chandoo.xlsm, one of my many open workbooks is Target.xlsx, and there are many worksheets in Target.xlsx.
I'm looking for a dialog process that will prompt me for which open workbook I want, then prompt me for which worksheet in the selected workbook I want to run the macro against. Make sense?
Right now, I have the VB editor open in one window, select a cell in the target workbook/worksheet, and then press F5 to run the macro. Or, I'm in the target workbook/worksheet, Alt-F8, and select the macro. Seems like there must be a better way.
Thanks, in advance.
I'm looking for a dialog process that will prompt me for which open workbook I want, then prompt me for which worksheet in the selected workbook I want to run the macro against. Make sense?
Right now, I have the VB editor open in one window, select a cell in the target workbook/worksheet, and then press F5 to run the macro. Or, I'm in the target workbook/worksheet, Alt-F8, and select the macro. Seems like there must be a better way.
Thanks, in advance.