+ Reply to Thread
Results 1 to 1 of 1

Code running twice and crashing after workbook saves

  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    Western Springs, IL
    MS-Off Ver
    Excel 2016
    Posts
    18

    Code running twice and crashing after workbook saves

    **I was able to figure out my issue so no need to respond to this post anymore**
    Thanks,

    Hello,
    I have the following code written to force a document to save a certain way but only when a certain field is filled in.

    My Workbook code:

    Please Login or Register  to view this content.
    And my Module1 code:

    Please Login or Register  to view this content.
    The two issues I am having is that the message boxes are popping up twice in a row before saving the document and then once the document is saved Excel freezes and says it's no longer working. The file does get saved correctly, but I have to close everything and reopen it to add more info. I would like the save message boxes to only popup once per time that the save button is clicked. Also, please help with the freezing issue at the end of the file save. FYI, I have a hidden sheet2 that has a small amount of data in it that I don't want users to be able to access. My file is attached in a zip file.

    Thank you in advance for any help.
    Last edited by ajam; 03-24-2016 at 01:55 PM. Reason: Do not need help anymore

+ 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 Crashing without Error when running macro
    By robbeh989 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2015, 07:08 PM
  2. Excel crashing when trying to view code before macro run; not crashing after first run
    By goonerforlyf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2015, 05:27 PM
  3. 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
  4. Excel 2010 keeps crashing when running a specific macro.
    By bean29 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2013, 07:36 AM
  5. Code running in the background- crashing computer, what is this??
    By KATIEexcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2012, 05:44 AM
  6. Code the saves filter info to reapply after running other code
    By Wedge120 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-25-2011, 05:49 PM
  7. Problem running macro that saves into a separate file (2007 issue only)
    By mikeenc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2009, 10:45 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