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.
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,
Bookmarks