Hope this sheds some light on what you needed.
What I have is even worse. I have a lot of macro's in XL4, using
activates, workbook.selects, ...
This is not working any more in XL5. Even the echo(true), echo(false)
commands r not there any more.
So my macro's run now showing all selecting cells in the macro sheet,
than jumps to other sheets, ...
Is there anything to do against it? It took more more then one month of
macro writing, and I'ld like the macro to keep working (using all
possible dialog boxes, and ading sheets that were made outside the
workbook to the workbook.
Also, I have to shift back, because I need my crosstab tables (I use
four different ones in one workbiik).
To all XL-wizards: is there a solutiop
Is there a way to change macro's that were written for XL4 workbooks
into a working XL5 macro?
I have a workbook, it contains a macro that activates several sheets in
the same workbook and copies things from one to another. Herefor, I use
alot of workbook.activate, WORKBOOK.SELECT and other workbook.macro
commands. These however are not recognized by XL5.
Since I spend a lot of programming on my macro's, should I drop the
problem and downgrade to XL4 again (after eeing the program I would
prefer to do this), or is there a program that changes macro's into
visual basic modeules for XL5.
IS there anyone out there that can convince me in some way that Visual
basic is a good thing, rather than a loss of time for experienced XL