Update protected cell calcs

[MartinL]

I want to protect all my hard work, but I also need the cells to update on change

I have two dropdown boxes that ripple changes throughout a spreadsheet

if i protect the sheet and then try to use the dropdown the excel tells me to bugger off

Do i really have to write an on update macro that uprotects the sheet makes the changes and then protects the sheet again.......

 

[Jonmo1]

You can just UNlock the cells that have the dropdowns...

Format - Cells - Protection - UNcheck "Locked"

Of coarse, you have to do that with the sheet unprotected.

 

[lenze]

A little more information. Are the cells with the Dropdown locked? If not, the formulas should re-calculate based on these being changed.
Are some of the changes the result of some WorkSheet Event, such as WorkSheet_Change? These will no not run without taking the proper steps.
lenze

 

[MartinL]

my mistake I meant combobox not dropdown

does make a difference

Im confuzzled

 

[lenze]

But, are the changes from formulas or Code? So, maybe

ActiveSheet.Unprotect "password"
ActiveSheet.Calculate
ActiveSheet.Protect "password"

lenze