Hi, i need help,
I have a shared file on a work network, A specific users should be defined to access this file and give everyone of them a password and permissions.
1- After saving the file the unblank cells automatically locked and can't be edit.
2- If sales man (user_1) write the code in column "C" ,the date of the transaction be filled automatically in column "A" in the same row of the Code.
3- The date that was filled automatically in column "A" should be a value not a formula.
4- Can track changes of the cells.
5- Hide all sheet taps, menu, formula bar and make the window in full screen mode ,but show header of columns and rows.
Thanks in advance.