Change the color of the Title Bar

[shajueasow]

Hi,
Is there a way to change the color of the titlebar ( for just a particular excel file) from Blue to something else. :wink:

 

[Haluk]

Open the related Excel workbook. Then hit Alt+F11 to switch to VBE window. From the menus, insert a module. Copy the code above and paste it as is into the new module that you've just created. Save the workbook and close. Afterwards, open the workbook again, the color of the title bar should be red.

 

[shajueasow]

Thank you Raider,
Thanks a lot for your code. I have tried that and found that it does what I want. Maybe some body else knows a way to control it so that it affects only a singleworkbook.
Thanks a lot

 

[Haluk]

You're well come......

But, as I've stated in my first message all the windows (message boxes, program windows, including excel - word - ...etc opened documents) their title bars will be changed with this coding and I believe there is no other way to change only the selected window's title bar color.