VBA - when click save button lock all cells with data in the workbook.

Hello all,

I know its not something new and I have gone through many threads where the cell gets locked if its contains data. That is when we type and move to another cell it locks the cell which contain data.
However, what I am looking for is, the cell should get locked only if:
1. The cell is not blank and user click save (Ctrl+S)
2. While closing we get an option to save and if the user clicks "OK".

Because the user should get chance to amend any cell while reviewing and identifies typo error or had selected any incorrect option from a combo box (data validation).

I have gone through below code and tried few stuffs but no idea how to involve save function in it which will lock all the cells in the workbook with data.
Can anyone help me out with this.

Please Login or Register  to view this content.

Checkout the Workbook_beforesave event, it is located in the workbook module.
.
WB_BeforeSave.jpg

hello Davesexcel, thanks a lot for your response however, I tried it but getting an error.

Please Login or Register  to view this content.

and event I tired a new code as well but its not going with the BeforeSave event could you please help?

Please Login or Register  to view this content.