Instead of inserting text into the cells, use:
Insert Comments
to hold the comment text.

In this way, the formula bar will not even be involved.
--
Gary''s Student - gsnu200820


"Diddy" wrote:

Hi everyone,

I've got a workbook that users fill in scores against a number of questions
and it calculates scores for each sheet and then total score.

The worksheet has a number of macros to help with the calcs but most are
formulas on each of the sheets so I have used protect interface.

My problem is that the last sheet of the book has three columns to allow
users to make additional comments. I've used three rows resized to about 150
and merged and text wrapped. Protection is off on these cells. I don't know
if this is the right approach or not???

What is happening now is that the text in the formula bar is obscuring the
cells on the sheet.

Is there a programatic solution or is there a way to get a message box
telling the user to clear the tick in View Formula Bar and then one saying
turn it back on.....

If anyone could help or make a suggestion it would be very much appreciated.

-
Diddy(confused and ready for Home)