A handy little modification. Can we do the same thing for Excel?
While I haven't been able to locate a "template worksheet", I have found that putting the code:
'
' Displays the Workbook Path in the Title Bar
'
ActiveWindow.Caption = ActiveWorkbook.FullName
In the Workbook_Open macro does show the path for that workbook.
|