Question

excel 如何通过命令按钮，用来 显示/隐藏 本按钮上的字？

按钮上有名字或签名，按一下就显示，并可打印。再按一下不显示了，但按钮还在，只是不会打印出来。

Answer 1

Public canPrint As Boolean
Private Sub CommandButton1_Click()
canPrint = Not canPrint
CommandButton1.PrintObject = canPrint
CommandButton1.Caption = IIf(canPrint, "赵钱孙李", "")
End Sub