Active Workbooks Displayed before Running Macro Code?

Hi,


I was hoping someone could help out with a snippet of code that I could display the active workbook name and give me the option to cancel or Run the REST OF THE code depending on the activew workbook that's active.


many times I run macros with various workbooks open and it always can slow down the process if the wrkbk I need to be active is not...

Thanks for anyfeedback and I doubt excel can let you see all the active workbooks and then select which one to run the rest of your macro on right?

Originally Posted by romperstomper

To just display the name of the active workbook and decide whether to continue or not:

Please Login or Register  to view this content.

For a list of workbooks, you'd need a userform really.

Thanks for the code, Can't you list all active workbooks and the turn those into variables or something?