Protect worksheet thru textbox

[techie131]

I am creating an excel worksheet that has an userform with a bunch of textboxes inputting data into the worksheet. I would like to set the worksheet to protected and only allowing data to be inputted by the userform. Can someone tell me how I can set that.

 

[SkipVought]

Hi,

There is no setting for that.

You must protect the sheet (use your macro recorder) for the user and then unprotect the sheet when your procedure changes the sheet and protect when you're done.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[techie131]

Would I have to make a macro for each sheet I have or is there a way to set it to protect all worksheets and only unprotect if the userform is started.

 

[techie131]

Hey Skip

I think I got it working with a recorder but I will probably set it to protect automatically when the workbook opens or when the sheet changes. That way only by opening the userform can they input data.

Techie131