Hi I am working in a small manufacturing unit and not well acquainted in Excel. It would be of great help to me if this forum could solve the problem mentioned below
Each column from its 6th row has to be locked after the date mentioned in 4th row and time mentioned in 5th row expires with respect to present date and time
The rows & Columns above 6th row are to be locked irrespective of anything
Further the cells in 1st and 2nd row will be merged randomly (because of which I am asking to lock from 6th row)
It would be better if it is password protected as I may be able to make changes for errors after time expiry
Thanks a lot in advance
Each column from its 6th row has to be locked after the date mentioned in 4th row and time mentioned in 5th row expires with respect to present date and time
The rows & Columns above 6th row are to be locked irrespective of anything
Further the cells in 1st and 2nd row will be merged randomly (because of which I am asking to lock from 6th row)
It would be better if it is password protected as I may be able to make changes for errors after time expiry
Thanks a lot in advance
