Hiding worksheets based on cell result

I have the following worksheets in Excel 2003:

Who Are You
Your Info Needs
Managing Records
Info Access & Retrieval
FOI, EIR & DPA
Other Comments

They form a questionnaire about information management FYI. I have a routine that totals what percentage of each sheet is completed. Using an if statement, I then assign a value of 0.166666666666666 to that sheet, and from there can calculate what percentage of the workbook is complete (0.166666666666666% * 6 =100%)

I would like to hide all but the first sheet until the 0.166666666666666 is achieved on that first sheet, then all but the first and the second until the 0.166666666666666 is achieved on the second and so on - i.e. until each sheet is completed, all subsequent sheets are hidden.

Can I adapt the following for hiding rows to sort this? If so, how?

Please Login or Register  to view this content.

Thanks for taking a look.

If the cell that you assign the 0.166666666666666 value to is a formula then you will will be using a Worksheet_Calculate event macro

Please Login or Register  to view this content.