Temperamental Excel!

Posted by Michele on August 20, 2001 3:02 AM

I have the following VBA code in "Sheet1(Sheet1)", "Worksheet", which sometimes works and sometimes doesn't.

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

What's wrong with EXCEL! What do we need to do to keep it's temper down and keep it's reaction constant?

Thanks
Michele

Posted by Damon Ostrander on August 20, 2001 10:48 AM

Hi Michele,

I can't seem to make this not work in Excel 2K. Of course, it won't work if macros are not enabled, but I assume you are always enabling them. Also, if you turn screen updating off, you will not see the formula bar disappear until screen updating is turned back on. These are the only things I can think of that could cause this problem. Is there anything else we should know about the context of this problem (e.g., it only happens on weekdays when the moon is full after eating a peanut butter sandwich...)?

Damon

PS. You didn't mention whether you have implemented anything to get the toolbar back. If you have, is there any possibility these two may conflict? For example, if you have a Application-level event that makes the formula bar visible, this could obviously override (or simply undo) the worksheet-level event you have.

Posted by Michele on August 21, 2001 7:39 AM

Hi Damon,

Well maybe it's something like you said - but not the peanut butter because we don't have any in Austria. Today it seems to work OK. If it comes up again I'll let you know along with details.

Many thanks,
Michele