Hi all
I've got a spreadsheet with several dropdown lists to show where an order is in its stages. As it can only be in one stage at any time, is there any way I can lock the rest of the lists so that they can't be altered until the stage is changed back to "No".
I've only got access to Excel 2003, so anything you can suggest would be great.
Many thanks
Chris
I've got a spreadsheet with several dropdown lists to show where an order is in its stages. As it can only be in one stage at any time, is there any way I can lock the rest of the lists so that they can't be altered until the stage is changed back to "No".
I've only got access to Excel 2003, so anything you can suggest would be great.
Many thanks
Chris
