Hi roy, thanks for ur help, but am still facing issues with the sheet.If i put value A and B alternatively in col H ,the code doesn't work anymore.Hope i have made myself clear to you.Let me know should you require more information from my side.
Ankur
The code I gave you checks each cell in Column H of the table of data to see if it matches C2, if it does it will lock or unlock the cells based on the selection in D2
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Roy, Can i have urs workbook?? In my workbook its not working.....Thanks for your help
Ankur
Roy,
Have attached the workbook with the mentioned code.pls help
I can't download the workbook, try zipping it.
I have winrar,will it work?
Ankur
zip it with any program, even Windows XP
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks