Post in the original thread.

Do not start a new one with any details whatsoever.

Whose macro? What does it do?

You could lock cells as the user saved the file using a BeforeSave event.

Yes, you can verify if the data is correct before locking the cell but what
would constitute "correct data"?


Gord Dibben MS Excel MVP


On Tue, 23 Oct 2007 15:56:10 -0700, joe wrote:

If there a way to only lock the cells after the user had saved the file? I tried your macro and it work really good, too good. :)

The thing is, if a user inputs the wrong data he/she will not be able to go back and make the necessary changes. Is there a way to allow the user to verify thier data entry before locking the cell?

Thanks in advance

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com