Odd status bar behavior


B

Burnnie Holliday

Here's an oddity that I can't manage to duplicate on my own workstation. I
have two seperate users on two seperate machines that occasionally "lose"
their status bar on Excel 2003. I watched this happen once, and the person
is never even touching the View menu. When the shared file finishes loading,
the status bar just simply winks itself out. Any ideas?
 
Ad

Advertisements

G

Gary''s Student

It is posible that the behavior results from the operation of an event macro.
If the following type of macro was in the workbook code area, the status bar
would dissappear when the file was opened:

Private Sub Workbook_Open()
Application.DisplayStatusBar = False
End Sub
 
Ad

Advertisements

B

Burnnie Holliday

I checked for that, and it isn't caused by a macro, even though there is an
open event programmed (Sheets(1).Select) that has nothing to do with the
status bar. It is nice to know that there is a VBA command for that, though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top