help needed  
Author Message
rolroc





PostPosted: Tue Dec 05 13:41:48 CST 2006 Top

Excel Programming >> help needed

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

Excel84  
 
 
Don





PostPosted: Tue Dec 05 13:41:48 CST 2006 Top

Excel Programming >> help needed 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



> 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





PostPosted: Tue Dec 05 13:59:10 CST 2006 Top

Excel Programming >> help needed 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.



> 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



>> 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
>>
>>
>
>


 
 
NickHK





PostPosted: Tue Dec 05 20:57:48 CST 2006 Top

Excel Programming >> help needed Gary,
Is the workbook shared with Track Changes? If so you cannot add code.
Or may be
http://support.microsoft.com/default.aspx?scid=kb;en-us;166492

NickHK



> 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





PostPosted: Wed Dec 06 11:14:50 CST 2006 Top

Excel Programming >> help needed No it's not shared.



> Gary,
> Is the workbook shared with Track Changes? If so you cannot add code.
> Or may be
> http://support.microsoft.com/default.aspx?scid=kb;en-us;166492
>
> NickHK
>


>> 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
>>
>>
>
>