+ Reply to Thread
Results 1 to 9 of 9

Making notes if the file is printed

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    69

    Making notes if the file is printed

    Good Day!

    It is possible in Excel that if i print the file then it will automatically appear in A1..."printed"?

    Thank You!

  2. #2
    Forum Contributor Dave H9's Avatar
    Join Date
    03-10-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    418

    Re: Making notes if the file is printed

    Hi znalron,

    That would be the before print event -

    Please Login or Register  to view this content.
    Needs to go in the workbook object of VBA.

    Hope that helps

    Dave H
    - Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
    - Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post

  3. #3
    Registered User
    Join Date
    09-10-2012
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    69

    Re: Making notes if the file is printed

    HI DAVE H9!

    I don't know how to use this.

  4. #4
    Forum Contributor Dave H9's Avatar
    Join Date
    03-10-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    418

    Re: Making notes if the file is printed

    See if the attached explains it.

    Cheers
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-10-2012
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    69

    Re: Making notes if the file is printed

    Thank you Dave H9!

  6. #6
    Registered User
    Join Date
    09-10-2012
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    69

    Re: Making notes if the file is printed

    TO: Dave H9

    Good Day!

    Can I ask another help & posted it here even though I marked it as "solved"? Thanks!

  7. #7
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Making notes if the file is printed

    you should start another appropriately titled thread, so that anyone searching for help can find it through the "search" option, that way many people can benifit from the answers given to your question(s)
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  8. #8
    Registered User
    Join Date
    09-10-2012
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    69

    Re: Making notes if the file is printed

    Ok thanks!

  9. #9
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Making notes if the file is printed

    You are welcome !

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1