Macro

M

MacroInHell

I am using excell 2002. My worksheet contained macros for date conversion and social security number conversion for data extraction (i.e. extract 19990101 convert to 01/01/99). Somehow now I am not able to access my macros. I tried to import the macros to the workbook and assign a button to it, however when i press the assigned button, it prompts me to a window to select the macro I want to use. Furthermore, when I select the marco, and try to run it, it does not run. Does anyone know what could be the problem for this?
 
D

Dave Peterson

If you hit alt-F8, do you see the list of procedures that are available?

I'm guessing no.

Excel2002 has the abililty to quarantine what it thinks are bad workbooks--it
keeps track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you'll want to put your backup copy in XLStart.
 
Top