I recorded 4 macros in the personal macro workbook. They worked fine until all of a sudden they were no longer available in the current workbook that I was working on. I have an "Excel inside out" book that says that you have to unhide it. I go to Windows/Unhide and this button is not even active on my workbook. There was another workbook open on the start menue that didn't have a worksheet in it, which I assumed might be the personal macro workbook. I clicked windows/unhide and a worksheet showed up on the screen. When I checked in this workbook (Tools/Macro/Macros) I see all four of the macros. But when I go to my other workbook (which I was currently working on) and I go to tools/macro/macros I don't see anything in there??? I am using excel 2003.
How can I fix this issue and make macros in pers macro workbook available everywhere as it should be? Thanks