View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bgale@ameritech.net is offline
external usenet poster
 
Posts: 1
Default 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)