2nd Save crashes Excel?

**Nola111** · 06-25-2014, 04:23 PM

Hi all,

I have the below code in ThisWorkbook. It serves two purposes - when a User first hits Save, it auto-populates fields of the Document Properties with values that are in certain cells. It also disables Save As altogether.

The problem is that anytime a user hits Save a 2nd time, Excel crashes. Can anyone see anything in my code that could be causing this. Is there a cleaner way to go about this? Finally, if all else fails, how would I code it such that this Sub runs on first Save but then "disables itself" from running after the first Save has been executed? I ask this because if I comment out all this code after the first Save, Excel does not crash on subsequent Saves.

Thanks!

Please Login or Register  to view this content.

**Nola111** · 06-26-2014, 10:29 AM

Let me just trim the fat on my above post and ask - how would I code it such that the above code is run the first time a user hits Save, then it is never run again on subsequent Saves??

Thanks.