ExcelBanter - Hide a form button

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hide a form button (https://www.excelbanter.com/excel-programming/310181-hide-form-button.html)

Michael Singmin

Hide a form button

Hello Group,

Does a form button have a visible function ?

Thanks,

Michael Singmin

JE McGimpsey

Hide a form button

DId you try it?

One way:

ActiveSheet.Shapes("Button 1").Visible = False

or, to toggle:

With ActiveSheet.Shapes("Button 1")
.Visible = Not .Visible
End With

In article ,
Michael Singmin wrote:

Does a form button have a visible function ?

All times are GMT +1. The time now is 02:02 PM.