Hi, I've searched around the forum and couldn't quite find a solution that would match my issue. Sorry if I end up re-asking a question though.
I've made a few pull down menus, hid the sheet with the actual data, leaving only the pull down menus available, and locked the sheets to provide different levels of accesses. However, when the file gets passed around to get information filled in, the pull down list would no longer exist, even though the value inside the cell is still inputted as the data validation formula.
Some suggests that it's because of the different versions of 2007 that is being used..., but I don't know how version differences would kill the data validation.
I'm using MS Excel 2007.
I've made a few pull down menus, hid the sheet with the actual data, leaving only the pull down menus available, and locked the sheets to provide different levels of accesses. However, when the file gets passed around to get information filled in, the pull down list would no longer exist, even though the value inside the cell is still inputted as the data validation formula.
Some suggests that it's because of the different versions of 2007 that is being used..., but I don't know how version differences would kill the data validation.
I'm using MS Excel 2007.