+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Printing count

  1. #1
    Registered User
    Join Date
    12-23-2011
    Location
    portugal
    MS-Off Ver
    Excel 2007
    Posts
    10

    Printing count

    Hello,
    i wanted for each time i print a document a cell for example a1 would increase its value +1.

    many thanks

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Printing count

    Try
    Please Login or Register  to view this content.
    Workbook Event code should be added to the workbook code module:

    Copy the Excel VBA code that you want to use
    Select the workbook in which you want to store the code
    Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
    In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
    Right-click on the ThisWorkbook object, and choose View Code
    Where the cursor is flashing, choose Edit | Paste
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    12-23-2011
    Location
    portugal
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Printing count

    thank it worked fine.

+ 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