VBA Autosave loop, based on conditions

[Steve1208]

Hello:

As mentioned above I am trying to write a VBA code to autosave my shared workbook, based on a couple of conditions, please read further for clarification:

The workbook as mentioned above is a shared document, up to 5 people will be editing and using the same workbook at the same time. To ensure the workbook is always live with current information it is required for each user to manually save the document constantly, this doesn’t always happen causing information get missed.

Therefore I’m looking for a code that will take that burden away from the user, but the code must only become activated and subsequently loop, based on a set of conditions:

Condition 1:
The workbook has been saved once already (manually)

Condition 2:
The date has been entered into cell E1


(Please note a simpler solution may seem to adopt a new package, such as ‘Once Note’ or similar, however the spreadsheet contains too much info, formulas and VBA to justify migrating the info and translating a new set of rules to a new software package)

Help would be greatly appreciated.
Thank you in advance.

 

[Joe4]

Note that there are some issues and limitations with shared workbooks.
See:
https://excel.tips.net/T002998_Losing_Data_in_a_Shared_Workbook.html
https://www.ablebits.com/office-add...-file-multiple-users/#shared-file-limitations

I don't really use them myself, because I have only heard of issues with them. I use Access instead, which is really better equipped to handle a simultaneous multi-user environment.

 

[Steve1208]

I understand the limitations, when using a shared document. However whenever changes need to be made and what would usually be limited functions to a shared document need to be added, the share feature is removed changes are made and the document is then reshared.

Access is a good programme, however as mentioned on my original I do not have the luxury of time to; migrate data or learn the benefits, limitations and language of a new platform.

I appreciate your input nevertheless.