Q:

How Do I Save the Right Version of My Excel File with Save Lockout Active?

I think I have my Excel VBA where I want it (checking for cell completion before allowing saving) but that also means I can't save the blank version of that form for distribution.  I'm probably missing something obvious but...I guess, disabling the macros and then reenabling it would work but apparently I can't figure it out.  I've tried googling it but I only get system-wide toggling.

A:

So, just to put a bow on things.  The correct way to deal with  this is to go through the formal file opening process in Excel.  Assuming you have the proper macro setting in Excel (disable macros with prompt), if you open Excel, Use File Open (DO NOT SELECT RECENT FILES) and browse to the file, select it and open.  Then you should get the standard prompt even if you've enabled it for that file in the past.

