Generating a numbered document
 

Hi
I have a macro which uses code to populate certain cells in a document and
then prints this page.
I would like to be able to use code to generate a sequential whole number
each time the macro is run and place this number in a cell on the document to
be printed. Thus whenever the document is printed it is numbered and this
number increases by one each time.

How can this be done please?

Generating a numbered document
 

Hi Alan,

explore workbook_beforeprint event.

Regards,
Ivan