Title of Excel workbooks

[Dmeighan]

My company has been using templates created in Excel that were set to Read-Only status many years ago. The title bar of these workbooks looks like this:
"Price Change Template - 1500 (v1.5).xls [Read-Only] [Compatibility Mode] - Microsoft Excel"

Our IT department made some changes to this template recently and now the title bar looks like this:

"Price Change Template - 1500 (v1.7).xls [Compatibility Mode] - Microsoft Excel"

The revised workbook still functions in read-only status, but staff are looking for that 'Read-Only' in the title bar and are a bit disconcerted not seeing it any more. How can this wording get added so it appears in the title bar as it used to?

Thanks!
Dori Meighan

 

[Jaafar Tribak]

Are you allowed to use Macros and edit the original template ? if so, maybe you could use the Window.Caption Property to change the title.

If you can't edit the original template file then you could still change the title of the workbooks in code via an addin or personal workbook.

 

[Dmeighan]

Are you allowed to use Macros and edit the original template ? if so, maybe you could use the Window.Caption Property to change the title.

If you can't edit the original template file then you could still change the title of the workbooks in code via an addin or personal workbook.

Thank you!