Formula Bar Contents Hiding Worksheet 2

[mattygriff]

I have a worksheet with a single large cell which takes text entry. However, when lengthy text is entered, the formula bar extends down the screen, hiding much of the worksheet.

The rest of the cell is protected so users can't move the cursor to another cell.

Is there any way to limit what is displayed in the formula bar to, say, a single line of text? Or is there any other way that I can overcome this problem?

Thanks in advance.

 

[mattygriff]

EDIT my post above - in the 2nd para, I mean that the rest of the SHEET is protected, not the rest of the CELL.

Sorry.

 

[SkipVought]

Hi,

Tools > Options > General ...

uncheck Show Formula Bar

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[mattygriff]

Thanks Skip - was hoping for a solution specific to that sheet which would let me keep the formula bar on the other sheets in my workbook but it does the job.

 

[DaveInIowa]

Try this in the worksheet's code module:

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

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

 

[mattygriff]

Thanks DaveInIowa - that's just the ticket.