Skip to Content
0
Former Member
Oct 31, 2009 at 10:58 PM

Dynamic Visibility not working because of toggle buttons initial cell value

29 Views

HIi All, hope you can help.

I have a model with 4 spreadsheet tabs : A, B, C & D

in cell A1 of sheet A, I control the visibility of some components using toggle buttons, I have three of them : Toggle 1, 2 & 3 which change cell A1 to the names of the tabs B, C or D.

When I preview the model, the A1 cell is already populated with B which is no good as I have components visibility dependent on that cell being empty to start with.

Can anyone help with this, what am I doing wrong, I want to build whole groups of components based on this control using dynamic visibility? I can post the model if that helps ?

Many Thanks,

Andy