Re: Please help - Runtime Error 13 on graphs

From: Sandra (anonymous_at_discussions.microsoft.com)
Date: 05/26/04

  • Next message: Sandra: "Re: Please help - Runtime Error 13 on graphs" 
    Date: Wed, 26 May 2004 13:22:04 -0700

    Jon, again thanks sooooo much for your help. Ok this is
    what I did. I looked for anything and I ended up finding
    a few things:
    1) It seems there were two versions of the same file
    open. I'm not sure why that is but it showed up in VB as
    two projects. Can you explain this? I didn't have it open
    twice!
    2) Two things I previously neglected to say is that we are
    using Win 2000 and Win XP. Win XP has the ability to
    insert into the footer (through Page Setup) the filename
    and path. Win 2000 can only insert the file name. We
    previously installed an add-in suggested on this web board
    so that our Win 2000 computers could insert the path also.
    Once we started getting the error, I tried removing that
    add-in but it didn't seem to change the error. But yes,
    both the Win 2000 computer and the XP computer both use
    the file and get the same error message. Secondly, when i
    was opening up the file before, i would get the question
    of whether i wanted to enable macros. So I figured there
    had to be a macro that was causing this problem, which is
    why I originally tried to get rid of the add-in.
    3) On the workbook level of each VB project, I found the
    following:
    ****
    Private Sub Workbook_BeforePrint(Cancel As Boolean)
        Active***.PageSetup.LeftFooter = "&8" &
    ActiveWorkbook.FullName
    End Sub
    *****
    I deleted this from both and reopened the file and lo and
    behold it didn't give me the error or ask if i wanted to
    enable macros.

    So did this fix the problem? Only time will tell. If you
    can explain any more please do, otherwise I will wait to
    see if this helped.

    Sandra

    >-----Original Message-----
    >It might be a Worksheet_Deactivate procedure: look for
    those on the
    >other sheets.
    >
    >It might be a workbook level procedure. Press Alt-F11 to
    open the VB
    >Editor, find your project in the project explorer (press
    Ctrl+R to
    >highlight this window), click the little plus sign if
    necessary to see
    >Microsoft Excel Objects, and that little plus sign if
    necessary to see
    >ThisWorkbook, then double click on this workbook. Do you
    see one of these:
    >
    > Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    >
    > Private Sub Workbook_SheetDeactivate(ByVal Sh As
    Object)
    >
    >Do other people have the problem with this file on other
    computers? Do
    >you have this problem with other files?
    >
    >- Jon
    >-------
    >Jon Peltier, Microsoft Excel MVP
    >Peltier Technical Services
    >Tutorials and Custom Solutions
    >http://PeltierTech.com/
    >_______
    >
    >
    >Sandra wrote:
    >
    >> Ok one more thing....I tried it again but I changed it
    >> to "Chart" from "General" in Visual Basic, and it gave
    me
    >> just:
    >>
    >> Private Sub Worksheet_Activate()
    >>
    >> End Sub
    >>
    >> There is nothing in between so I don't know what the
    >> problem is.
    >>
    >> Sandra
    >>
    >>
    >>>-----Original Message-----
    >>>Thanks Jon for your timely response. Unfortunatley,
    when
    >>>I do the "view code", it is just blank. there is
    NOTHING
    >>>and I have tried everything. What am I doing wrong?
    How
    >>>do I view the code? I know there must be something
    there
    >>>but everythign is blank.
    >>>
    >>>Sandra
    >>>
    >>>
    >>>
    >>>>-----Original Message-----
    >>>>Sandra -
    >>>>
    >>>>There is some kind of macro that is kicked off when
    you
    >>>
    >>>activate the
    >>>
    >>>>*** with the chart. Right click on the *** tab,
    and
    >>>
    >>>select View
    >>>
    >>>>Code. If you see a line that says
    >>>>
    >>>>Private Sub Worksheet_Activate()
    >>>>
    >>>>select the line and press the F9 key. Then keep
    pressing
    >>>
    >>>the F8 key as
    >>>
    >>>>the macro steps through, and see which line is causing
    >>>
    >>>the error. Ask
    >>>
    >>>>someone there for assistance, or post back with the
    code
    >>>
    >>>that's causing
    >>>
    >>>>problems. Clearly indicate which line is the bad one,
    >>
    >> and
    >>
    >>>use a
    >>>
    >>>>technique to indicate it that is visible on a text
    only
    >>>
    >>>newsreader
    >>>
    >>>>(e.g., put a line of asterixes above and below the bad
    >>>
    >>>line, don't color
    >>>
    >>>>it red or bold it).
    >>>>
    >>>>
    >>>>- Jon
    >>>>-------
    >>>>Jon Peltier, Microsoft Excel MVP
    >>>>Peltier Technical Services
    >>>>Tutorials and Custom Solutions
    >>>>http://PeltierTech.com/
    >>>>_______
    >>>>
    >>>>
    >>>>Sandra wrote:
    >>>>
    >>>>
    >>>>>On one of our workbooks we have several graphs that
    >>>
    >>>pull
    >>>
    >>>>>information from the other worksheets within the
    >>>>>workbook. When I click on the tab (work***) that
    >>>>>contains the graph(s), I get the message "Runtime
    >>
    >> Error
    >>
    >>>>>13: Type Mismatch." This error has given us a lot of
    >>>>>problems and has even screwed up data in this and
    >>
    >> other
    >>
    >>>>>open workbooks.
    >>>>>
    >>>>>Please, can someone help me figure out how to look
    >>
    >> into
    >>
    >>>>>this problem? I know very little about graphs in
    Excel
    >>>
    >>>so
    >>>
    >>>>>please be very details and step-by-step.
    >>>>>
    >>>>>Sandra
    >>>>
    >>>>.
    >>>>
    >>>
    >>>.
    >>>
    >
    >.
    >

  • Next message: Sandra: "Re: Please help - Runtime Error 13 on graphs"
    • Quantcast