I'm creating a workbook with multiple userforms and the users can only see the userforms and not the excel sheets.
For the moment the workbook can't be closed before they fill in all the necessary userform and when all is filled in then the workbook closes by it self.
I was wondering that there is an easy way to close prematurely a workbook like that (for example when they are half way and don't have the necessary time to finish) and save it as draft. And that this workbook can be open afterwards to continue with all the userforms filled in as before.
Because i supose that when i close a workbook, all userforms are unloaded and i lose all info and because i have multiple userforms with plenty of inputs it will be a major job to wite every single input to a sheet so i can be used afterwards.
Thanks in advance.