Excel 2007 : Can't hit "Enter" in text box when worksheet is protected

[lrussell20]

When sheet is not protected, I can hit "Enter" and it will go to the next line within the text box. If the sheet is protected, it will jump out of the text box and into the next cell. The users will only be able to use a protected sheet. Is there a way to fix this?

Thanks!

[abousetta]

Hello and welcome to the forum. Can you show us your code that goes with the button?

[Richard Buttrey]

What do you mean by a Text Box? Are you referring to an Activex Form Control object.

Or are you referring to a cell? When you Protect a sheet all cells are locked by default. You need to unlock any cells you want to be able to access before protecting the sheet.

Upload the workbook if you still have problems.

Regards