Basically, the macro uses keystrokes to iterate through different number formats, fonts, etc. It's extremely useful when modeling. I'd love to have it back!
|Check out our Excel VBA Resources|
Bad news : you have to re-write it in VBA (no quick way).
Good news : you should still be able to use the XLM without re-writing it in VBA
I'm pretty experienced with most of Excel's command, but never did learn VBA. I've always recorded macros by hitting 'record' and going through the steps.
Can you tell specfically how to convert this file using XLM. If it's too difficult for a 'beginner', than is their someone you can recommend to do it for me.
You have to know VBA to convert your XLM.
But .... you can run your XLM in Excel 2002.
Just open the file containing the macro and run it.
Thanks for the response. I seem to be getting errors when I try to iterate to a different format. The dialog box says their is an error in the macro, and presents some options to solve them which requires VBA skills, I imagine.