Hi
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
I have divided my excel sheet in five parts. Each section has two to four drop down menu.
Is this possible to lock all the section except the section 1. Once I complete all drop menu of section 1 than, section 2 only becomes unlocked and its back ground colour changed to different colour.
Also, once I complete Section two than Section 3 become unlocked with changed background colour and keep going like this.
Most imortant only required field are unlocked on the excel sheet all other cells are locked.
Or,
Make the command button at the end of each section to unhide & unlocked next section after completing the existing section otherwise show warning complete this section first.
thanks
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>I have divided my excel sheet in five parts. Each section has two to four drop down menu.
Is this possible to lock all the section except the section 1. Once I complete all drop menu of section 1 than, section 2 only becomes unlocked and its back ground colour changed to different colour.
Also, once I complete Section two than Section 3 become unlocked with changed background colour and keep going like this.
Most imortant only required field are unlocked on the excel sheet all other cells are locked.
Or,
Make the command button at the end of each section to unhide & unlocked next section after completing the existing section otherwise show warning complete this section first.
thanks
