Pete
08-28-2008, 08:14 AM
see attached workbook
Hi
how would i amend the following vba code in (module essential) so after the mag box appears warning the users that they have already assigned the essential position...the second essential position goes back to what ever scenario it was......(i.e. the text in cell c7 does not change from scenario x to essential position)...
For Example: Say if scenario 1 is the essential position and then we try and also assign scenario 2 to also be the essential position.....then this cannot happen.....the user must manually amend the previous assigned cell (c7 in any of the scenario worksheets back to its scenario name - as per worksheet tab) - before they can re-assign another scenario as the "essential position"...
i hope this makes some sense...........
Hi
how would i amend the following vba code in (module essential) so after the mag box appears warning the users that they have already assigned the essential position...the second essential position goes back to what ever scenario it was......(i.e. the text in cell c7 does not change from scenario x to essential position)...
For Example: Say if scenario 1 is the essential position and then we try and also assign scenario 2 to also be the essential position.....then this cannot happen.....the user must manually amend the previous assigned cell (c7 in any of the scenario worksheets back to its scenario name - as per worksheet tab) - before they can re-assign another scenario as the "essential position"...
i hope this makes some sense...........