Unlocked cells in Protected worksheet are getting automatically locked while execution of macro in Excel 2007 thus preventing execution of further statements in the macro. For this particular case it is occuring while using "Range.Select" and "Range.clear" methods.
Alternatively i am using activesheet.unprotect and activesheet.protect to solve this problem which is not a real solution.
Could anyone suggest reasons for the same.
Not without seeing your code.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
The code corresponds to dynamic updating of list based on change in value of a particular cell.Originally Posted by Domski
Please find the code below:
C4:D4 is the cell value which is tracked such that a change in this merged cell will update list in cell C6:D6. The cells C4:D4,C5:D5,C6:D6 are unlocked and the Sheet1 is protected.
Please Login or Register to view this content.
Regards,
Mahe
Last edited by asapu_mahe; 03-05-2010 at 01:46 AM. Reason: Include attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks