Excel Caption

[dave3009]

Hi Folks

Just a minor help request. Is it possible to change Excels application caption to read something different from 'Microsoft Excel - book Name.

I looked at script editor but couldn't find anything I could change.

Tried >> Application.Caption. And that didn't work.

Thanks


Dave

 

[northwolves]

execute the macro below:

Sub Macro1()
Application.Caption = "MicroHard-------------->"
End Sub

 

[dave3009]

Thanks

I didn't try the = sign.

Thank You


Dave

 

[Jon Peltier]

Keep in mind that if you then try to use mail merge with Word, that Word will not be clever enough to find Excel with a changed caption.