How to turn Forumla Bar off for just one sheet? 2

[Quintios]

I'm using Excel 97. I have a sheet that has instructions in each cell and clicking on that cell results in the forumla bar getting huge. So I turned it off. However, that seems to be a global setting as it's turned off in all the other sheets in the workbook.

How can I either turn the forumla bar off for the one sheet or keep it from expanding so that it covers half the screen when I click on a cell with a lot of text?

Thanks in advance! Onwards,

Q-

 

[Dreamboat]

Q:

IMHO, don't do it that way. Put your instructions in textboxes instead. That's what I do. And then I protect the sheet too so they can't drag the textboxes around. Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[xlbo]

But if you do wanna go that way, just put this code in the WORKSHEET module:

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


Private Sub Worksheet_Deactivate()
With Application
.DisplayFormulaBar = True
End With
End Sub
Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[Quintios]

One star for each of you; good suggestions.

I believe I need to keep the instructions in cells as I've grouped them by category so the enduser won't have to scroll all over the place. They just click the appropriate + button on the left and the instructions for that section expand.

But the subs, that's what I was looking for. Cool.

Thanks to both of you! Onwards,

Q-