+ Reply to Thread
Results 1 to 3 of 3

Edit VBA code without automatically executing code

  1. #1
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Edit VBA code without automatically executing code

    Got myself into a foolish situation.

    I have a procedure that runs automatically when the workbook opens. When the application finishes I recently put in a application.quit.
    Now I can’t get in to edit the code - it runs and quits when I open the workbook. I’m using a Surface and I can’t even find the break key!

    Is there any way to edit the code without triggering the automated start of the code?

  2. #2
    Registered User
    Join Date
    01-11-2015
    Location
    Barcelona, Spain
    MS-Off Ver
    2010
    Posts
    1

    Re: Edit VBA code without automatically executing code

    I think you could try to:
    a)Open the workbook while holding de "shift key" to dissable the Workbook_Open procedure.
    or
    b) Dissable macros before opening the workbook
    Hope it helps.

  3. #3
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Re: Edit VBA code without automatically executing code

    Thanks Vogelfrey - I didn't think of disabling macro's. That did it and I'm back in action. Thank you very much.

+ 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. edit in code for populate range of cell in list box and code for delete any items
    By mazan2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2017, 03:33 PM
  2. [SOLVED] This code not working in a Protected Sheet, can any one pls edit this code
    By rajeshn_in in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2016, 01:08 AM
  3. [SOLVED] VBA code comes out of a program wihtout executing whole code
    By Thor Almighty in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-19-2015, 06:39 AM
  4. Can i avoid Locked Cells Using this Code getting Updated How can i edit this code
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-01-2014, 03:27 AM
  5. Unable to edit macro recording code to be a relative code.
    By holaitsme in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2014, 10:51 AM
  6. How do I edit this code to make it update automatically?
    By Matt2014 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2014, 11:13 AM
  7. [SOLVED] do anybody have a sample code for executing excel macro from vb code?<eom>
    By B Deepak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2005, 05:05 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