Grappa
01-22-2008, 02:43 AM
Hi,
Really appreciate if someone could advise the best mechanism to update a footer on saving a workbook.
I have following code that updates the footer:
Private Sub UpdateFooter()
Dim Ws As Worksheet
For Each Ws In Worksheets
Ws.PageSetup.LeftFooter = "Test"
Next Ws
End Sub
I don't seem to be able to find a mechanism to call this when the user saves the file.
Any help appreciated.
Simon
Really appreciate if someone could advise the best mechanism to update a footer on saving a workbook.
I have following code that updates the footer:
Private Sub UpdateFooter()
Dim Ws As Worksheet
For Each Ws In Worksheets
Ws.PageSetup.LeftFooter = "Test"
Next Ws
End Sub
I don't seem to be able to find a mechanism to call this when the user saves the file.
Any help appreciated.
Simon