VBA Code to automatically save work Item

Hi

Does anyone have a code I can add to my User Form that when they click the button to add item
it automatically saves the workbook.

As I have a shared wookbook where other members of the team add completed items but if they forget to save the workbook
and when they then log out and it asks to save the workbook

Another staff member may have added items to that row and thus a message comes up do you want to save your item or the item already in that row

This could then overwrite what is already in that row.

Thanks

Hi Winon

Thanks for the reply

I am new to VBA coding so this is my first attempt at writing the code and creating user forms

So any help and advice would much appriecated

Hi Winon

That is great works okay

Am I able to amend the code to hide Completed work tab as this will then not allow users to overwrite on this workbook.

Many Thanks again for your help