I want to allow my program to save .txt or .xlsx files with VBA code (i do this to export data not save the entire program) and at the same time allow user to secure save the original program. Currently I can let it save with vba code but when i try to save the original program, it says it saves but does nothing. If i configure it to allow secure saves it will create a secure save but when i use the vba code to save data, it will save but then after it saves it pops up with a secure save after it. So my vba code asks for a file name and save location then after its done the secure save pops up asking for a file name and location again. How can i stop the double save?
