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

[caranjo]

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

[Static]

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

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

[caranjo]

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

[Static]

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

Thanks!