how to restrict editing a worksheet after finalising inputs?

Originally Posted by HaHoBe

Hi, jetlee,


Maybe lock all cells on the worksheet and protect the sheet with a password. Make all formulas values for the copy of that worksheet. Add a code that will only allow to reach empty cells on that sheet.


Yes, maybe have a look at Mail from Excel and make/mail PDF files (Windows) as a starting point and work from there on.

Ciao,
Holger

hi,
good idea, i will give it a go.
thank you