$$Excel-Macros$$ workbook location on status bar

2011-07-03 Thread netuser501
Hi, Is there a code or a build-in option to have the location path of a workbook permanently showing on the Excel status bar? Thanks Pascal -- -- Some important links for excel users: 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ workbook location on status bar

2011-07-03 Thread STDEV(i)
'--Thisworkbook Module:-- Dim OldStaBar As String Private Sub Workbook_Open() OldStaBar = Application.DisplayStatusBar Application.DisplayStatusBar = True Application.StatusBar = ThisWorkbook.FullName End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean)

RE: $$Excel-Macros$$ workbook location on status bar

2011-07-03 Thread Rajan_Verma
: Re: $$Excel-Macros$$ workbook location on status bar Hi Pascal, Please Try the below way... In 2007 Go to Excel options ---Customizeall commonds---document Location ---add in quick access toolbar and see the below.. -- Best Regards, Venkat On Mon, Jul 4, 2011