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
'--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
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