Excel Title Bar and Icon

[ChrisTheAncient]

I know it can be done in Access, but can it be done in Excel (using Excel 2002 but would like it to happen in older versions)?

Can I change the icon in the title bar in Excel to my corporate icon that I use in Access and can I change the wording in the title bar to be a bit more meaningful than just the workbook name?

I've browsed the Excel help pages - with not a lot of help!

TIA

Chris *************************************
OK, I'm stoopid. But I'm good at it!
*************************************

 

[Loomah]

Chris
I think this can only be done in code and as I don't have a full answer for you I'd suggest reposting in the VBA forum.

But to get you started 'Caption' is a property of the 'Application' object which can be set - to a certain extent.

Try running this line of code from a standard module

Application.Caption = "My Application"

You'll see that, unfortunately, it leaves the original file name in the title bar. Set caption = empty to clear it.

That's about as much as I can tell you!

BTW Im using xl2k, it works in 97 but I can't remember ever using it in an earlier version.

Happy Friday
;-) If a man says something and there are no women there to hear him, is he still wrong?