View Single Post
 
Old 04-14-2011, 09:22 AM
CGM3 CGM3 is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default

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.
Reply With Quote