hi,
i have a excel sheet of daily load list on network drive where every body can add and edit what they want to load for particular date, i want to lock the sheet 3 days before the actual date of loading. for eg i have 31 sheets for month of jan. on all sheet date of loading is typed and cell can be protected. so 3 days before that date i want the sheet to be locked and only certain user can edit it. how do i do this? please help.. thanks..
i have a excel sheet of daily load list on network drive where every body can add and edit what they want to load for particular date, i want to lock the sheet 3 days before the actual date of loading. for eg i have 31 sheets for month of jan. on all sheet date of loading is typed and cell can be protected. so 3 days before that date i want the sheet to be locked and only certain user can edit it. how do i do this? please help.. thanks..