I have been searching for days for this solution. I expect anybody can help out. I have an Excel workbook consisting of 3 sheets. Sheet 1 is my workspace. 2 of the worksheet have the entire the information in a sheet which I created two validations. I place one in A8 (doing things over it, typically cosmetic things) I also place a validation based on B8 A8. That works well. So essentially when I choose as of a dropdown list A8 Departments which gives me the option to choose the employee associated to that department and once chosen, CD and E are full as well. Now I have two questions for you. How can I create it empty one so while the user opens it up is empty and they have to choose a department to begin off? How can I lock it in order that no modifications can be done? Essentially I desire to be view only. Please reply fast.
Bookmarks