I am getting Unable to record

[Guest]

Franz from Italy suggested putting the following code into the View Code
"Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Not Intersect(Target, "A1") Is Nothing Then Call MyMacro
End Sub"

but now I am unable to record or view the code for any macros (and I'm not
still recording a previous one). I have deleted that code but still can't
record.

 

[Dave Peterson]

First, I would think you'd want something more like:

If Not Intersect(Target, me.range("A1")) Is Nothing Then Call MyMacro

And do you still have the same problem if you close excel and reopen it?

Where are you recording the macro--in personal.xls or the activeworkbook or a
different workbook?

Is there a chance that you're recording to personal.xls and it's corrupted
enough so that excel closed it?

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep 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 may want to delete that copy and put a copy
of your backup version into your XLStart folder.

(If you don't have a backup, take the time now and create one.)