moving from excel 11 to excel 12

[Nemo]

Excel 2007, wXP

New XP computer with Excel 2007 (Excel 12) and leave my old computer with
Excel 2003. I had a bunch of macros in the old computer, but I believe they
were not all attached to specific spreadsheets and I could see a list of all
macros and invoke the one I wanted. With the Excel 2007 computer it seems
that the macros were imported attached to the workbooks to which they
pertained, but I had a few macros in the old system that could be used
anywhere, such as one that caused a "comment" to be written without my
initials embedded in it, and it could be used in any worksheet.

I suspect those "unattached" macros are in there somewhere, but I can't find
them. Where do I look for all macros presently in Excel 2007?? How do I
import them to be used anywhere?

Thanks

 

[Michael Bednarek]

Excel 2007, wXP

New XP computer with Excel 2007 (Excel 12) and leave my old computer with
Excel 2003. I had a bunch of macros in the old computer, but I believe they
were not all attached to specific spreadsheets and I could see a list of all
macros and invoke the one I wanted. With the Excel 2007 computer it seems
that the macros were imported attached to the workbooks to which they
pertained, but I had a few macros in the old system that could be used
anywhere, such as one that caused a "comment" to be written without my
initials embedded in it, and it could be used in any worksheet.

I suspect those "unattached" macros are in there somewhere, but I can't find
them. Where do I look for all macros presently in Excel 2007?? How do I
import them to be used anywhere?

Have you looked in PERSONAL.XLS on your old computer? Also, inspect the
list of Add-Ins which might refer to some XLA-s. Another way of looking
at all this is the Project Explorer (Ctrl+R) in the VBA Editor
(Alt+F11).