customize your status bar..

Posted by Joe on April 02, 2001 8:34 AM

how can we display greetings at status bar
such as " Welcome and enjoy this program "
every time we open the file and the greeting
will remains at the status bar moving like
in a web browser. thanks

Posted by Dave Hawley on April 02, 2001 11:41 AM

Joe, right click on the sheet picture, top left next to "File" and paste in this code:

Private Sub Workbook_Activate()
Application.StatusBar = " Welcome and enjoy this program "
End Sub

Private Sub Workbook_Deactivate()
Application.StatusBar = ""
End Sub

Dave

OzGrid Business Applications

Posted by Joe on April 02, 2001 10:47 PM

Posted by Dave Hawley on April 03, 2001 1:25 AM

Move where ?

OzGrid Business Applications

Posted by Joe on April 03, 2001 2:52 AM

Re: Move where ?

Hi again Dave..what I meant is the greetings will
move at the status bar as long as the user open
the workbook. Its just like at some web pages. Is
it possible?

Thanks

Posted by Dave Hawley on April 03, 2001 3:13 AM

Re: Move where ?

Joe, if you mean 'scroll' then i'm afraid it cannot be done in Excel. The example i gave will stay on the status bar (static) as long as the workbook is active. If they activate or Window into another Workbook it will dissapear

dave

OzGrid Business Applications