Preventing students from viewing future assingments

John_P490Hiding the channel does not make it invisible to students. Students will see the channel under 'Hidden channels' and can view the channel at any time from their channel list even if you set it as hidden by default. There is no way to set a date to change a hidden channel to 'Show'.

A better approach for this would be to schedule the individual assignments to post at a specific future date and time. They will then appear at the set date and time in the channel and won't be visible to students beforehand even if students can see the channel.  To schedule an assignment in the future, click 'Edit' just under the due date:

Then check the box to 'Schedule to assign in the future' and choose a 'Post date' and 'Post time' then click 'Done':

John_P490 

:: Caveat :: This solution is for Excel only.

What you are trying is only possible by using VBA macro.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim AssDate As Date
    AssDate = Range("A1").Value
    Dim Currdate As Date
    Currdate = Date


    If Currdate = CDate(AssDate) Then

        ActiveWorkbook.Sheets(1).Visible = xlSheetVeryHidden
        

    Else
        ActiveWorkbook.Sheets(1).Visible = xlSheetVisible
        
    End If
End Sub

How it works:

To invoke VB Editor to use this code,  you will need to press Alt+F11.

• Then Copy & Paste this code.
• Return to the sheet & Save the WB as Macro enable *.xlsm.
• Write the date in cell A1 on which you want to un hide the assignment.

N.B.

• If and when the Current date will equals to the Assign date this code will unhide the Sheet/Sheets. 
• You may hide & unhide as many sheets.
• This is editable, and you may use formula as needed to compare, Current Date ( Currdate  )  with Assignment Date ( AssDate ).

If Currdate = CDate(AssDate)  Then