time stamp when printing

[maximus0120]

Is there a way to have a date/time stamp entered into a cell when a worksheet is printed?

[Legend Rubber]

yes... what cell would you like it in?

[Legend Rubber]

If you want it in B1 then

Please Login or Register  to view this content.

[maximus0120]

Still having a little trouble, trying to put it in cell B39, tried just changing the cell, doesnt seem to be working..

[Legend Rubber]

Please Login or Register  to view this content.

[maximus0120]

nevermind, figured it out, pasting the VBA in the wrong place....Thanks for your help.

[Legend Rubber]

that works for me in B39