placing a title at the bottom of the screen

**mfairhurst1** · 06-23-2013, 05:37 PM

Hi Everyone

In excel 2003 I know you could put a title at the bottom of the screen i.e. created by Michael Fairhurst (see attachment for the location of this). If I remember correctly this was done via a macro. does any one know how to do this in excel 2010?

My spreadsheet is also attached if you want to give it a go

Thanks

Mike

**TMS** · 06-23-2013, 05:53 PM

Place the following code in the Workbook module of your workbook. Save the workbook as a macro enabled Excel spreadsheet (.xlsm)

Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.StatusBar = False
End Sub

Private Sub Workbook_Open()
Application.StatusBar = "Created by Michael Fairhurst"
End Sub

Close the workbook and open it again.

Regards, TMS

**martindwilson** · 06-23-2013, 05:56 PM

http://www.excelforum.com/excel-prog...he-screen.html

**TMS** · 06-23-2013, 06:00 PM

Ditto what Martin said ...

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.