i will try and explain this the best way I can.
In my spreadsheet, I have a macro that is triggered when the user clicks the save button or clicks ctrl(cmd for mac)+s. I have done this mapping by going to tools → customize.
In certain scenarios, I need to give the user an option to save the file as new file. That is if the user clicks save and certain conditions are met, ( a major change in price for ex) the macro which gets triggered before saving will give the user an option to save our file as a new one. However the changes also get saved in the old document as the user has already pressed save.
Is there any way to kill the first save process using libre basic? If not I will need to think of a workaround for my scenario.
Edit: My LO version is 6.3 on macos 10.13.6