title a the bottom of the screen

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

Hi Everyone

I am looking at putting a line of text at the bottom of the screen i.e. created by Michael Fairhurst. I have done this before in excel 2003 and I am wondering how to do it in excel 2010. Please see location doc to see what I mean. Also attached is my spreadsheet, feel free to give it a go. Im pretty sure it is a macro but it could just be a general setting in excel

thanks in advance

Mike

**FDibbins** · 06-23-2013, 05:39 PM

...putting what?

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

Its a line which goes at the bottom of the screen - you can basically put who the document was created by etc - see attachment for location. I have done it before in excel and also access but this was back in the 2003 days of excel and now I am on 2010 and not sure how to do it. It might not be a macro, it could have been a general setting somewhere in excel

thanks

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

sorry, edited that, didnt realise it that it didnt upload all my text

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

Application.StatusBar = "your text"
see here in your other thread TMShucks has given a fuller answer
http://www.excelforum.com/excel-prog...he-screen.html

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

Please don't post the same question twice, especially within 10 minutes of each other. It's a waste of everyone's time!

See the answer in your other thread for a more full example of the code required and where to put it.

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.

**arlu1201** · 06-24-2013, 06:52 AM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.