Changing the Text in Excel's Program Title Bar

[HangMan]

I'm running the following code which both creates new worksheets and deletes a number of rows based on a range of different criteria. Initially when running the code Excel goes to sleep showing (Not Responding) in the Program Title Bar and then the whole screen goes white (so it looks like Excel has crashed) which is not very encouraging for the end user.

I've added a Do Events line to the code (I'm unsure if it is sitting in the correct place), which at least stops the whole screen going white and allows the menu's and main Excel screen to remain visible and I've also added a message in the status bar, however this doesn't prevent Excel's Program Title Bar from displaying (Not Responding).

Is there a way to change the Title Bars text to say 'Processing...' or similar?

Also have I placed the 'Do Events' line in the correct place, is it doing what it should be doing?

Please Login or Register  to view this content.

Many thanks

[TMS]

Examples courtesy of Ozgrid:

Please Login or Register  to view this content.

You could also put something in the Status Bar.


Regards, TMS

[HangMan]

Hi TMS,

I've already have something in the status bar, though to be honest, you kind of have to know it's there if that makes sense, I doubt most end users even notice it. I'll give this a go and let you know how I get on...

What is the difference betweem the 'Application.Caption' and the 'ActiveWorkbook.Windows(1).Caption'?

Many thanks

[TMS]

Well, it's not something I use, but the clue is in the object names ... Application and ActiveWorkbook.


Regards, TMS

[HangMan]

Um, okay so far adding...

Please Login or Register  to view this content.

Isn't preventing the Program Title Bar from displaying (Not Responding), does this need to be used in conjunction with anything. I'm using it like this:

Please Login or Register  to view this content.

The Status Bar text shows quite happily but not the Windows Caption. Am I missing something?

Many thanks

[TMS]

Nothing is going to stop the title bar from displaying Not Responding. It usually means that you have a big and/or sluggish workbook with a lot of formulae or Conditional Formatting ... and it's just busy calculating when you're trying to interrupt it.

[HangMan]

Well, yes, there are several thousand formula in the workbook, though it's not particularly sluggish...

I'd wrongly assumed that there was a way to prevent the (Not Responding) status appearing... It seems a bit of an oversight as it doesn't really send out a great message to the end user. Are there any simple methods to show the end user that the file is still processing and hasn't simply hung that wouldn't add to the processing time of the macro.

The macro has a lot of data to process and can take a long time to run so the user isn't really given any clues to show the file is still running, the hourglass doesn't really mean a lot. I guess because there is nothing physically moving, like a progress bar it is hard for the user to tell and whilst it is running it would be pain if the user simply thinks it has crashed and hits esc to stop it mid way through...

If I were to use something like this to give a visual clue...

Please Login or Register  to view this content.

how do I specify the X and Y values in the code?