PDA

View Full Version : Only allow one input at any given time



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...........

Bob Phillips
08-28-2008, 08:46 AM
You have posted non-working code again. It refers toa sheet11 and there is no sheet11 ...

Pete
08-28-2008, 09:10 AM
i had to hide one of the worksheet(s) must have acciodentially deleted it as the file size was to big to up load...the limit on this site is 1M.....even when zipped...

Pete
08-28-2008, 09:43 AM
Ok here is a modified version........