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

And, in which forum would you like the answer? See your other post. This is
the better one for your question. Why not post your coding efforts or tell
us details of what you are doing.

--
Don Guillett
SalesAid Software

"Gary" wrote in message
...
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

I did not get the answer...that's why posted it again. sorry for that. I am
actually not writing the code....I am simply recording the macro.

"Don Guillett" wrote in message
...
And, in which forum would you like the answer? See your other post. This
is the better one for your question. Why not post your coding efforts or
tell us details of what you are doing.

--
Don Guillett
SalesAid Software

"Gary" wrote in message
...
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,
Is the workbook shared with Track Changes? If so you cannot add code.
Or may be
http://support.microsoft.com/default...b;en-us;166492

NickHK

"Gary" wrote in message
...
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

No it's not shared.

"NickHK" wrote in message
...
Gary,
Is the workbook shared with Track Changes? If so you cannot add code.
Or may be
http://support.microsoft.com/default...b;en-us;166492

NickHK

"Gary" wrote in message
...
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