Pascal,
Yes you are right
I have said for 2007 &2010 Version...
*Best Regards,*
*Venkat*
*
*
On Tue, Jul 5, 2011 at 4:05 AM, netuser501 wrote:
> thanx,
>
> Venkat solution is most practical for 2007 since it works on all
> workbooks that work and don't work with vba code.
> I guess the
thanx,
Venkat solution is most practical for 2007 since it works on all
workbooks that work and don't work with vba code.
I guess the vba code for this is for Excel 2003?
Pascal
--
--
Some important links for excel
: Re: $$Excel-Macros$$ workbook location on status bar
Hi Pascal,
Please Try the below way...
In 2007 Go to Excel options --->Customize>all commonds--->document
Location ---add in quick access toolbar
and see the below..
--
Best Regards,
Venkat
On M
'--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)
Application.DisplayStat