thisWorkbook.Save going to TMP file
When executing thisWorkbook.Save, it is saving the TMP file which excel creates, and not saving the actual workbook.
The command is executed behind ThisWorkbook Code (under Microsoft Excel Objects).
There is a user form being used to update data on the workbook (based on what user inputs to the form), then then click Save. But it is not saving the actual workbook, only saves temp file (CVT300 -- found under C:\Documents and Settings\<USER_ID>\Local Settings\Temp). This mean when another user opens the form, they do not see the changes made by previous user. Any advice on how to correct this?
If Cells(7, 1) = 1 Then