I have float over tools that used to open and work with a keystroke based on the active workbook, but in Excel 2013 it is unpredictable.
In the backend activeworkbook may not be the last workbook you were looking at because of this multiple ap focus nonsense. Is there a workaround anyone knows of? Like
activewindow. activeworkbook.name?
IE if I am looking at Jan sales and hit a keystroke to open a form from a hidden utility, it may or may not switch to Feb sales or some other unrelated workbook.
If I am looking at Jan Sales, a floatover form should do just that. Float over whatever was visible when hit. This is screwing up other things Ive seen.
Code people wrote expecting activeworkbook to mean something it no longer means. Anyone know a workaround in VBA, that's not 300 lines of C# or shell scripting?
Is there one line of code to replace activeworkbook.name in Excel 2013?
In the backend activeworkbook may not be the last workbook you were looking at because of this multiple ap focus nonsense. Is there a workaround anyone knows of? Like
activewindow. activeworkbook.name?
IE if I am looking at Jan sales and hit a keystroke to open a form from a hidden utility, it may or may not switch to Feb sales or some other unrelated workbook.
If I am looking at Jan Sales, a floatover form should do just that. Float over whatever was visible when hit. This is screwing up other things Ive seen.
Code people wrote expecting activeworkbook to mean something it no longer means. Anyone know a workaround in VBA, that's not 300 lines of C# or shell scripting?
Is there one line of code to replace activeworkbook.name in Excel 2013?
Last edited:
