+ Reply to Thread
Results 1 to 4 of 4

Excel Crashing with VBA that was working

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    Minnesota, US
    MS-Off Ver
    Excel 2010
    Posts
    15

    Excel Crashing with VBA that was working

    Hello Everyone,
    I have a perplexing problem I need some experts to look at.

    I have a pretty simple set of VB command buttons I was working on. One Deletes blank rows from the compiled list, the next sets page breaks at cell value change in a column, the last resets the page. This sheet is just for printing purposes.

    I had these working fine for a few hours, tested at least a hundred times with different option sets available in the workbook, did some additional formating and saved new file for every major change. I came back after being away for about half an hour and then the sequence of buttons would crash excel. I would go to previous versions of the file and it would work once or twice then crash, after a file crashed once the file would never again work even though I never saved. Didn't matter how far I went back in previous versions it would do the same thing. Tried rebooting, tried opening on different computers, no change.

    I re-did some of the codes and I got the "Remove blank rows" button and "Reset Page" buttons to work without crashing and then I saved and now it crashes...

    I'm not at all an expert with this stuff at all, so, could be the codes or could be a problem with my excel or computer?

    Here are the command button codes.

    Please Login or Register  to view this content.
    These are all under "Sheet 4" which is named Sheet1 in the workbook because I hadn't renamed it yet.
    Here is the workbook also.

    Thanks for any help, it is much appreciated,
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Excel Crashing with VBA that was working

    Copy of PT 30(7).xlsm

    it works for me now, i moved your buttons, and form controls into modules instead of on the sheet code

    I'm not sure the exact reason, I'm guessing that it has something to do with how sheet code works vs how modules work, also, I had to remake your buttons so they would work, so you might want to do a bit of formatting of the buttons to they look the way you want them to look

  3. #3
    Registered User
    Join Date
    09-21-2012
    Location
    Minnesota, US
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Excel Crashing with VBA that was working

    Thank you sooo much! It was such a weird issue, I'm glad you could help, and in such a timely manner as well.

    Much appreciated!

  4. #4
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Excel Crashing with VBA that was working

    no worries, glad to help

+ 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