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 |
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 "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 |
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. "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 |
help needed
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 |
help needed
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 |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com