Hi,

I am trying to record a macro wherein I would just unprotect the sheet,
correct a small error in a formula and then protect the sheet.

I start recording, I unprotect the sheet, I correct the formula and the
moment I press ENTER i get an error "Unable To Record"

I have never seen this error before.

Please Help.
Gary

Gary wrote:
Hi,

I am trying to record a macro wherein I would just unprotect the sheet,
correct a small error in a formula and then protect the sheet.

I start recording, I unprotect the sheet, I correct the formula and the
moment I press ENTER i get an error "Unable To Record"

I have never seen this error before.

Please Help.
Gary

Just fixed the problem here on my end. In my case I had successfully
recorded to my PERSONAL.XLS workbook, then manually edited the file
introducing a syntax error
(Options Explict rather than Option Explicit). From this point forward
could not record to PERONSAL.XLS, and got the error "Unable to Record
Macro". After I fixed the syntax error recording worked normally.

Bill (not MVP)