how to restrict editing a worksheet after finalising inputs?

[jetlee]

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

[HaHoBe]

Hi, jetlee,

how can i restrict editing a workbook after i press submit button?

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.

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

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

[jetlee]

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

[jetlee]

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 ?

[HaHoBe]

Hi, jetlee,

could you either be more specific about what to protect or what code you recorded/tried out? Maybe even attach a workbook to demonstrate what you want.

Ciao,
Holger

[jetlee]

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