I have a spreadsheet that is used to create printouts. The user must go through many stages to get to the final point where they can then finish the process.

Along the way i set the status to different values to identify what functions/buttons are available and what marcos can run.

I have about 50 different macros/buttons and about 15 stages.

rather than writing long winded code asking if statements like 

Please Login or Register  to view this content.
Would there be another way referring to a table which indicates what state the buttons will be in depending on the state? I would have a table with states and button names and a value of true or false in the middle of the table.

p.s the above code is very much longer, but i think it helps to show what i am currently doing.

thanks in advance