[RESOLVED] How do you change what is displayed on the bar at the top of an Excel doc???

Hi all,

The bar reads Microsoft Excel -Book1 as you all know

but I want to get it to read Microsoft Excel <somebody's name here>- Book1

Does anybody know how to do this?

Thanks in advance

carlos

to get this to happen on ALL workbooks will take some programing..
you will need to create an add in or a hidden workbook (placed in the XLSTART folder)
that traps Excel Events...

but to do it one wkbook at a time

VB Code:

Private Sub Workbook_Open()
    Application.Caption = Environ("username")
End Sub

thanks...great solution!!! much appreciated!

No problem. If this is resolved could you Mark it? (Click thread tools > Mark thread Resolved)

Thanks!