Excel Protection problem

R

routeram

Hi,

I have a chart with a button on it. The button is used to evoke
userform that can be used to change parameters on the data sheet an
see how the graph varies. I have code in both the userform an
worksheet modules.

I now want to protect the data sheet. Since protecting the sheet woul
prohibit any change on the sheet, I am unprotecting the data sheets i
the userform_initialise and protecting them back i
userform_terminate.

I want the user to change the parameters both via the sheet and th
userform. However the worksheet module code will not run properly whe
change is made via sheet cos the sheet is protected. Unprotecting an
protecting back in the worksheet module messes up the userfor
functioning. Any way to get around this?

Thanks.

Regards,
Ra
 
Top