jungix
09-07-2006, 12:11 PM
Hi,
I would like to create a worksheet with some unlocked cells for the user to put inputs, and then launch a macro that writes the outputs in some other cells. I would like to lock the cells containing the outputs. How can I unprotect the sheet in my macro, and protect it again afterwards? Note that the user won't have the password to unlock the cells.
I hope I was clear enough.
Jungix
I would like to create a worksheet with some unlocked cells for the user to put inputs, and then launch a macro that writes the outputs in some other cells. I would like to lock the cells containing the outputs. How can I unprotect the sheet in my macro, and protect it again afterwards? Note that the user won't have the password to unlock the cells.
I hope I was clear enough.
Jungix