function CheckProtection(){
    ActiveSheet.Protect()

    // Check the ability to insert columns on a protected sheet.
    // Notify the user of this status.
    if( ActiveSheet.Protection.AllowInsertingColumns == true){
        MsgBox("The insertion of columns is allowed on this protected worksheet.")
    }
    else{
        MsgBox("The insertion of columns is not allowed on this protected worksheet.")
    }
}