Macro Error "Unable to record"
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)
|