Contents of Formula Bar overflow cells

[Diddy]

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)

 

[Gary''s Student]

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.

 

[Diddy]

Hi Gary's Student,

Thank you for your answer but I've got protected cells to make sure users
enter info where we want it so the insert comments is greyed out.

The more I learn it seems the less I know!

My other problem is that I don't have any contact with the end users and I'm
still very much learning but because of the lack of contact I'm trying to
make it as easy to use and as foolproof as possible. A job for a far more
capable person than me but a great learning experience!

Many thanks

 

[Jim Cone]

Right-click the last sheet tab and choose "view code".
Paste the following into the big white window...

'--
Option Explicit
'Hides/shows the formula bar.

Private Sub Worksheet_Activate()
Application.DisplayFormulaBar = False
End Sub

Private Sub Worksheet_Deactivate()
Application.DisplayFormulaBar = True
End Sub
'--

Jim Cone
Portland, Oregon USA




"Diddy"
wrote in message
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)

 

[Diddy]

Thank you Jim,

Fantastic solution!
Cheers
Diddy