Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Can't stop VBA script from running

  1. #1
    Join Date
    23rd July 2004
    Posts
    274

    Can't stop VBA script from running

    Hi Guys,

    I was working on a workbook yesterday and now it won't open.

    The workbook has two worksheets, I created a userform with a 2 page multipage (1 for each worksheet) to get info from each sheet. I had finished page 1 with all the correct scripts, I had checked it to make sure it worked. I then copied all from page 1 to page 2 and started changing the scripts accordingly, I got about half way through when I lost power to my laptop.

    I now open the workbook, but it locks up as if it is running a script but looping and I can't stop it. I can't attach it as it is too big (409kb), if anybody can suggest how I can open it and stop whatever is looping I would be greatfull.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,708
    Hi simpsonc2

    Try opening from within Excel, while holding down the Shift key. This will prevent any Workbook Open/Activate Event macros running.

  3. #3
    Join Date
    23rd July 2004
    Posts
    274
    Dave,

    I tried what you suggested and got the following message???

    "Cannot open Microsoft Excel Add-In for editing. Please edit the source document instead"

    Any suggestions

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    17,903
    Try opening your workbook without enabling macros, then check your code to se if you can locate the cause. Check the Workbook_Open and Activate first. If it auto runs the userform on opening check the userform_initialise event
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  5. #5
    Join Date
    23rd July 2004
    Posts
    274
    Thanks Roy,

    I have managed to open it so I will check all the macros for the fault.

    Thanks again, I don't know where I would be without this forum.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Backup Script Stop Working
    By C-zeb in forum EXCEL HELP
    Replies: 5
    Last Post: May 17th, 2007, 04:03
  2. Stop Userform Running Macro
    By LBailey in forum EXCEL HELP
    Replies: 5
    Last Post: May 14th, 2007, 17:32
  3. Accessing multiple files and running a script
    By kobekat in forum EXCEL HELP
    Replies: 1
    Last Post: May 23rd, 2006, 13:35
  4. How to stop VBA code running
    By musictech in forum EXCEL HELP
    Replies: 15
    Last Post: July 6th, 2005, 09:38
  5. Running Script on all Sheets (Varying # of Sh
    By cw_lynn in forum EXCEL HELP
    Replies: 2
    Last Post: March 13th, 2004, 00:17

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
  •  
porno