I have a spreadsheet which contains two tabs both protected (and need to be).
The Customer Details tab has a dropdown in it that a alters a value so it is either 0 or 1.
This value is in cell R5 (on the customer details tab).
When this value is 0 I want Row 9 in PV Calculator tab (which already has a macro in its view code that does something else) to un-hide or continue to show its ROW 9.
When the value above is 1 then I want the PV calculator tab row 9 to be hidden. It must be updated by the time the user clicks this tab not after they click inside the tab. (It is hiding a drop down).
I am not very good at this kind of thing.
I need to use View Code I guess in CUstomer Details to add a macro that affects the PV calculator tab in this way but at the same time does not compromise the fact that both need to be protected.
The Customer Details tab has a dropdown in it that a alters a value so it is either 0 or 1.
This value is in cell R5 (on the customer details tab).
When this value is 0 I want Row 9 in PV Calculator tab (which already has a macro in its view code that does something else) to un-hide or continue to show its ROW 9.
When the value above is 1 then I want the PV calculator tab row 9 to be hidden. It must be updated by the time the user clicks this tab not after they click inside the tab. (It is hiding a drop down).
I am not very good at this kind of thing.
I need to use View Code I guess in CUstomer Details to add a macro that affects the PV calculator tab in this way but at the same time does not compromise the fact that both need to be protected.
