Protection issues
 

Hello! I have an issue with protection, and I would appreciate any
solutions to my problem.

I have a number of worksheets in my workbook that allow for user input
(in a limited number of cells). I have a command button that will
reset certain values back to defaults. I want my worksheets to be
protected. I have made sure to make unprotected certain cells, command
buttons, text boxes and combo boxes. But I still have the issue that
when I try to reset my cells to defaults (this is done by a command
button), I get an error msg informing me the sheets are protected. Is
there some way I can manage to fix this? My worksheets need to be
protected. I thought I had handled this appropriately. Any ideas?

Thanks,
Julia

Julia,

Wrap your button code in:
activesheet.unprotect
activesheet.protect

HTH

" wrote:

Hello! I have an issue with protection, and I would appreciate any
solutions to my problem.

I have a number of worksheets in my workbook that allow for user input
(in a limited number of cells). I have a command button that will
reset certain values back to defaults. I want my worksheets to be
protected. I have made sure to make unprotected certain cells, command
buttons, text boxes and combo boxes. But I still have the issue that
when I try to reset my cells to defaults (this is done by a command
button), I get an error msg informing me the sheets are protected. Is
there some way I can manage to fix this? My worksheets need to be
protected. I thought I had handled this appropriately. Any ideas?

Thanks,
Julia