hello.
i am working on a excel workbook project and basically its a LOCKED sheet for users with certain rows having access to check, type in or select certain project code/vendors/etc...
i want to set it up so that when the users open the sheet, they must answer the questions in ORDER and populate the cells before moving forward (making it so that the form is complete before PRINTING). i dont know if there is a way to avoid writing code and maybe use excel formula's instead since having to "enable the content" might not go smoothly with some users.
i wanted to know what code do i write so that the user has to go in order from start to end. the first question requres user to click the box near YES or NO. only when the answer from that question is given, can the user move forward to the next row or #2.
its a little difficult to explain.
if anyone has a g-mail and is willing to help me via e-mail since the blog/forum will get excessive & with g-mail you can chat...it would be much appreciated.
thanks!
-uu
i am working on a excel workbook project and basically its a LOCKED sheet for users with certain rows having access to check, type in or select certain project code/vendors/etc...
i want to set it up so that when the users open the sheet, they must answer the questions in ORDER and populate the cells before moving forward (making it so that the form is complete before PRINTING). i dont know if there is a way to avoid writing code and maybe use excel formula's instead since having to "enable the content" might not go smoothly with some users.
i wanted to know what code do i write so that the user has to go in order from start to end. the first question requres user to click the box near YES or NO. only when the answer from that question is given, can the user move forward to the next row or #2.
its a little difficult to explain.
if anyone has a g-mail and is willing to help me via e-mail since the blog/forum will get excessive & with g-mail you can chat...it would be much appreciated.
thanks!
-uu