Display document version number in Header or Footer?
Please excuse my limited knowledge, but I'm not sure exactly what to do with
the subroutine below. Perhaps you could provide intstructions of where to
paste this code or a link to instructions on it.
"Gord Dibben" wrote:
Does this work?
Sub Stuff_In_Footer()
With ActiveSheet.PageSetup
.LeftFooter = _
ThisWorkbook.BuiltinDocumentProperties("Revision number")
End With
End Sub
Gord Dibben MS Excel MVP
On Fri, 3 Apr 2009 06:18:02 -0700, Kevin Hancock
wrote:
I'm using the Document Managemen Server and would like to have the version
number of a file displayed in the footer along with the filename. I have the
filename appearing fine, but can't figure out the variable for "Version".
I tried &[Version] , but no luck.
|