Inserting a PATH into the footer...

Hi Joanna

Not without VBA!

Right click on the sheet picture with the X on it, top left next to "File" and paste in this code over the top of what you see. Push Alt+Q to return to Excel and Save.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim Reply As Integer, Filepath As String
Reply = MsgBox("Hello Joanna, would you like the file path ?" _
, vbYesNo, "OzGrid.Com")
If Reply = vbYes Then
Filepath = Me.FullName
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = Filepath
.CenterFooter = ""
.RightFooter = ""
End With
End If
End Sub

Any good ?

Dave

OzGrid Business Applications

You can also use the CELL function, however, you cannot insert this formula in the footer. Try using the following formula at the end of the sheet. type... =CELL("filename")

Hope this helps...