Results 1 to 3 of 3

Thread: Print a selected chart

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Oct 2005
    Posts
    20

    Question Print a selected chart

    I have a chart on a worksheet of an open workbook. The chart name is “test”
    I ask from a user to print the selected chart with default printer. For this reason (prints) I have setup the "adobe postscript printer" with port location the file “test.txt”
    I would like to see if the user actions are correct (selects the chart and prints the selected chart). I can’t find the right way to do this. First I have to check if the user makes the right movements in excel and then check the file test.txt so I can find if the user calls the print command.
    Any ideas ?
    Thanks

  2. #2
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Print a selected chart

    Private Sub Workbook_BeforePrint(Cancel As Boolean)

    End Sub

    you could test for the selected object in the before print event
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Oct 2005
    Posts
    20

    Re: Print a selected chart

    Thanks for your help but I try to do this from external vb6 app. Not from excel (VBA)

Posting Permissions

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



Click Here to Expand Forum to Full Width