+ Reply to Thread
Results 1 to 3 of 3

Code closing workbook as soon it opens

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Code closing workbook as soon it opens

    I have the following code in my workbook open modeule
    Please Login or Register  to view this content.
    This is part of some code that closes the workbook if no activity occurs after the time value given in cell H5.

    The value in this cell before was 00:00:15 and I tried to change this value to 00:01:00 but somehow when I pressed enter on the cell the value became 00:00:00 and before I had chance to amend it my original 15 seconds elapsed and now I am stuck with the workbook closing 0 secs after I open it.

    I have tried holding down 'Esc' key as I open the workbook to break the code it's not working! I'm in danger of losing an awaful lot of work here, is there anything I can do ti stop this code from running as I open the workbook so that I can edit the value?

    Any help would be much appreciated!
    Last edited by adam2308; 10-13-2012 at 02:35 PM.

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Code closing workbook as soon it opens

    Have you tried holding down SHIFT when opening the file to prevent it from running macros?

    If that doesn't work, open a different file, set your security level to high and prevent macros from running. Then try to open your problematic sheet.

  3. #3
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Re: Code closing workbook as soon it opens

    Panic Over!!! I eventually managed break the code from executing!

+ 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