Posted by johno on November 12, 2001 6:22 AM
i am working on a workbook which contains 6 sheets
valid, valid1, valid2
invalid, invalid1, invalid2
The valid2 and invalid2 are my final sheets and depend on calculations carried out in the respective sheets before them.
How do i carry out a macro on valid2 and invalid2 when they have been populated? surely using auto_open there is a chance that the macro will be performed without checking if the two final sheets have been populated with values????