Hi. Im a new member and hope you can help. I ve got a fairly routine Excel (not extraordinarily complex that is) billing system created for me in Excel 98. It uses macros that create new workbooks for invoices and statements etc.
When I run it on both OSX platforms in Office X, I have noticed a glitch. The new workbook doesn't end up on top as the active workbook as it is supposed to. It is hidden under both the "master" workbook which contains all the macros, and an expenses workbook that is opened as part of the macro commands.
further, If I go get it, make it active and click on it, its unresponsive! And if I click too often, OSX thinks Ive crashed and ...well, crashes/quits.
I have to first click on that 'master' file once like a magic "touchstone" .... and then select the new workbook and all is fine.
But of course that's sloppy and a waste of time.
Any ideas on a solution?? My guy has already tried altering the macro so that it does this little touch dance automatically to no avail
When I run it on both OSX platforms in Office X, I have noticed a glitch. The new workbook doesn't end up on top as the active workbook as it is supposed to. It is hidden under both the "master" workbook which contains all the macros, and an expenses workbook that is opened as part of the macro commands.
further, If I go get it, make it active and click on it, its unresponsive! And if I click too often, OSX thinks Ive crashed and ...well, crashes/quits.
I have to first click on that 'master' file once like a magic "touchstone" .... and then select the new workbook and all is fine.
But of course that's sloppy and a waste of time.
Any ideas on a solution?? My guy has already tried altering the macro so that it does this little touch dance automatically to no avail