Convert this short Private Sub into a macro (1 Viewer)

[Valery]

Hi all!

I took this coding off the Internet and it works (along with a module). But I would rather have it into a macro than having to copy/paste into each report where I need it.

Please provide detailed explanations as to what is to be selected in the macro drop downs.

THANK YOU!

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
    Call SetGrpFtrLoc(Me.Report, 8.5)     'Display report footer at least
                                        '5.5 inches from the top of the page
End Sub

 

[arnelgp]

there are no equivalent macro for this.