+ Reply to Thread
Results 1 to 3 of 3

.xla macros not running properly after getting at code

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-14-2014
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2013
    Posts
    339

    .xla macros not running properly after getting at code

    I'm wondering if someone here could take a look at some macro code to figure out why it is not working properly.

    Some background.
    The original code worked fine when I loaded it into worksheets.

    Then I wanted it to start automatically in a certain worksheet.
    For me, this meant getting at the code in VBA.
    When I tried to do this I learned the .xla macro was password protected.

    After I figured out how to get at the code and copied it into my .xls file
    the macro is not running properly.

  2. #2
    Forum Contributor
    Join Date
    02-14-2014
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2013
    Posts
    339

    Re: .xla macros not running properly after getting at code

    OK I am making progress but still need to do some cleaning up and could use help here.

    What I did was download the original .xla file and this time I installed it properly.
    Now when the .xls file is opened the macro shows up on the menu as an add-on, which is fine.

    But I would like to clean up my code in the VBA editor (Alt-F11).

    When I go there I see VBAProject (xl2qif.xla) which is completely password protected.
    Above that are the files that I had previously unprotected from the xl2qif.xla file.

    I suspect that the code I need to keep is the password protected code.
    I don't know how to delete all the other code which consists of:
    Forms
    Modules and
    Class modules

    TIA!

  3. #3
    Forum Contributor
    Join Date
    02-14-2014
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2013
    Posts
    339

    Re: .xla macros not running properly after getting at code

    OK I managed to delete the other code and now am left with just the password protected VBA code.

+ 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. Excel 2010 crashing when running macros....my code?
    By dietcoke802 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2013, 05:56 PM
  2. [SOLVED] Code not running properly! Getting error message
    By mwolfe571 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2013, 02:01 PM
  3. [SOLVED] VBA code running in wrong order and not executing properly
    By ollylondon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2012, 10:11 AM
  4. Macro not Running Properly in Excel 2003
    By Progress2007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2008, 08:36 AM
  5. [SOLVED] running macros/vba code in a shared environment
    By Eric in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2005, 08:06 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