+ Reply to Thread
Results 1 to 12 of 12

VBA Chart initialization!!

  1. #1
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    VBA Chart initialization!!

    Hey friends!!
    I have an interactive chart in a workbook.
    I have a code as below on workbook

    Please Login or Register  to view this content.
    Ok well, it works totally fine on my computer, main objective of the above code was that the user dont have to run macro everytime they open the workbook.
    But when i try it on other computer, i have to run macro for once(Or close file and reopen it)... chart does not interact on first use of the file.
    In the first time, if we run macro and without saving reopen it, then it works...
    How can i solve my problem??
    Last edited by meus; 01-22-2015 at 05:30 AM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: VBA Chart initialization!!

    Check whether any other code (any macro code) is turning OFF the event before opening this file

    Or

    Enter this code in immediate window and open the file.

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: VBA Chart initialization!!

    I have checked in the immediate windows
    Please Login or Register  to view this content.
    And it says true..
    Confused whats going on..

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: VBA Chart initialization!!

    Use stop to check whether the event is running or not

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: VBA Chart initialization!!

    Yes the Event is running... it goes perfectly fine in mine... but when i transfer file to my frens computer, at first opening, the event wont run, and after you close and reopen, it runs again... strange

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: VBA Chart initialization!!

    What is the excel versions of both the systems?

  7. #7
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: VBA Chart initialization!!

    both of em are 2013... I tried using 2010 as well.. but nothing helped...

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: VBA Chart initialization!!

    I call all members help for this thread

  9. #9
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: VBA Chart initialization!!

    Thank you...

  10. #10
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA Chart initialization!!

    Does the event not run at all, or does it just not do whatever it is supposed to do to the chart?
    Remember what the dormouse said
    Feed your head

  11. #11
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: VBA Chart initialization!!

    Event does not run at the first use of the file.
    At the first use of the file in a different computer, the event does not work... either you have to run a macro or just simply closing and re-opening again runs the event... I have tried this in almost 10-12 different computers, some having 2010 and some having 2013 version but same problem occurred..

    But after then, it runs perfectly as i programmed.
    Last edited by meus; 01-22-2015 at 11:13 PM.

  12. #12
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA Chart initialization!!

    Does it do that with every other computer or just your friends computer??
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. UserForm Initialization
    By WThornton59 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2009, 09:31 AM
  2. UserForm Initialization issue
    By WillysK5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2009, 12:26 PM
  3. array initialization
    By stanigator in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2007, 05:40 PM
  4. Re: Annoying prompt: ActiveX and app initialization
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2005, 10:06 PM
  5. UserForm Initialization
    By Patrick Simonds in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2005, 05:47 AM

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