+ Reply to Thread
Results 1 to 3 of 3

VBA Code dosent run after close & reopen

  1. #1
    Jagdip Singh Ajimal
    Guest

    VBA Code dosent run after close & reopen

    I have a complicated wooksheet, whereby I have created code to handle
    calculations. When I first create this page and test it, everything
    works great.
    But, as soon as I close and reopen the file, the worksheet doesnt want
    to run any code.

    Does anyone know why? If you require more info, such as the code, I
    can tell you. But it doesnt seem to be relevant to the problem.

  2. #2
    JE McGimpsey
    Guest

    Re: VBA Code dosent run after close & reopen

    Where are you storing your code?

    Are you using UDFs or event macros?

    What is your security settings set to?

    In article <c84eb1b0.0504250301.21334f44@posting.google.com>,
    jsa1981@hotmail.com (Jagdip Singh Ajimal) wrote:

    > I have a complicated wooksheet, whereby I have created code to handle
    > calculations. When I first create this page and test it, everything
    > works great.
    > But, as soon as I close and reopen the file, the worksheet doesnt want
    > to run any code.
    >
    > Does anyone know why? If you require more info, such as the code, I
    > can tell you. But it doesnt seem to be relevant to the problem.


  3. #3
    jsa1981@hotmail.com
    Guest

    Re: VBA Code dosent run after close & reopen

    It turns out it was the macros. I didnt know that the Worksheet's
    change event was counted as a macro.
    My security settings disabled all macros. As soon as I turned it off,
    it started woring correctly.


+ 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