Dear Excel Experts, Can you please suggest me the code for following task.
My sheet is password protected and Column B is locked. When user try to enter the data in any cell of column B, I want to open one user form. I am comfortable with build the user form. In my user form I have six TaxtBox, I want to write the data of user form in same sheet active row column C to H. I know the write the user form data in new worksheet, but I don’t know the code to write the data in active row and also the code for open the Userform, if my cell is locked. Pls help. Thanks in Advance… Regds, Manish Pansari +91 9810 88 8281 -- ---------------------------------------------------------------------------------- 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
