Share via

Strange behaviour when sheet protected

Anonymous
2010-09-06T14:49:43+00:00

On my worksheet I have some protected and unprotected cells and that works ok.

I also have a text box for adding comments, the text box is unlocked so that comments can be added when the sheet is protected.

When the sheet is unprotected then typing is ok in the text box however when I protect the sheet it acts strangely.

If I start typing in the text box that is ok until I press enter to go to a new line and the cursor jumps off the text box and on to one of the cells much further down the page. Is it something I am doing or not doing. I have tried locking and also unlocking the underlying cells but that doesnt seem to alter it.

thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2010-09-07T09:27:28+00:00

Problem now resolved, it was being caused by the underlying cells being protected and causing the cursor to jump to the next available cell.

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2010-09-08T05:52:26+00:00

    Glad to know that the issue is fixed.

    Was this answer helpful?

    0 comments No comments