Hi Team, Request you to help me creating an assessment sheet wherein the person taking the test, once chooses the option given in column C, the particular cell should freeze...
If the question is given B3 cell and the corresponding answers in C3 (either drop down or need to key in ... depending upon the question) Sample sheet is attached... the movement the option is chosen by the person, the cell c3 should freeze and make it unalterable -- Thanks and Regards Vinod Narayanan -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Freeze Cells.xls
Description: MS-Excel spreadsheet