Greetings - just wondering if there is a better workaround than locking and unlocking a textbox to edit it programmatically. Excel 2011 does not play with locked textbox like the windows versions. On Windows (and 2004 I believe) you can update the textbox without issue via code, but the improvements in 2011 seem to have changed how locked textboxes are handled.

Of course, I could just unlock the textbox - but I have it locked and provide a scrollbar for people to update values.

I think this makes sense without code, but if someone wants to see it I can mock up a workbook to attach.

There is a post on the topic at http://answers.microsoft.com/en-us/m...a-7aacea26b1b6 , and the answer is to unlock the textbox. There is also an assertion that the 2011 actually handles textboxes correctly, and it is the win versions that have it wrong...I actually see the point the MVP there is trying to make, but wouldnt that be a first?