Thank you Jim,

Fantastic solution!
Cheers
Diddy
--
Deirdre


"Jim Cone" wrote:

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)