Hi all, Need Help...
I have a user form in which i have 6 check boxes. ok and cancel button. when ever I click 1st check box, rows 1 to 10 should to be editable, rest all rows should be non editable and hidden. For check box 2, rows 11 to 20 editable, rest up and down area should be non editable and hidden. And vice versa for other check boxes. I need a macro for this. Attached is the excel sheet with user form created in background. Thanks in advance, Rsh -- ---------------------------------------------------------------------------------- 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
test.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
