Do you mean the spreadsheet or the worksheet?? If I protect the spreadsheet control I get runtime error. I haven't protected the worksheet also.
With Rorys code I could write in the columns referenced in the the spreadsheet in user form but the values does not get copied into the worksheet.
I'm trying to get a code that would not allow the user to write in the protected columns of the spreadsheet. as they have formulas they need to be updated from the referenced cells. and also get copied to the worksheet.
Thanks a million Rory I have finally figured out how the code works and I've put the code under the Userform_Initialize event making the cells to be locked as the user form loads. Now I could move from cell to cell with the help of the tab button on the keyboard.
What I'm trying to do is that when the user form is loaded the sheet 1 to be visible in the spreadsheet control. When the click of a macro button I want to switch to sheet 2 in the same spreadsheet control which would be referenced to another worksheet in my workbook.
In short; a macro code that would switch from Sheet 1 to Sheet 2 of the same spreadsheet control.