将wps弄成两列(WPS表格Excel设置某两列为必填项)

1.WPS表格（Excel）如何设置某两列为必填项

可以使用excel vba命令实现：

Private Sub Workbook_BeforeClose(Cancel As Boolean)

For i = 2 To 100 '假设到从C2到C100为必填数据

If Cells(i, 3).Value = "" Then

MsgBox "C列仍存在空格！不能退出EXCEL!"

Cancel = True

Exit For

End If

Next i

End Sub