how to restrict editing a worksheet after finalising inputs?

hi there,

how can i restrict editing a workbook after i press submit button?
there is the details:
i have a workbook that i want to input some figures in, and by pressing "submit" button to lock it and no further editing to be available?

also i haven't got the "submit" button yet inputted as i'm waiting for a code

is possible same time with Submit to send and email to certain email address?

thanks in advance

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

can't get the code right.......
i only need to lock a certain column after pressing the submit button ( same column on several sheets on workbook )so no further editing.
any help ?

got the code right this time and works fine ...............
thanks for all the help holger