Hide a form button

  • Thread starter Thread starter Michael Singmin
  • Start date Start date
M

Michael Singmin

Hello Group,

Does a form button have a visible function ?

Thanks,

Michael Singmin
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable hide for a column 2
Determine the USB drive 9
What is the purpose of a Macro Sheet ? 1
Disabling font color button 1
Identify selected chart 3
Wrong type of Listbox from VBA 5
Sumproduct with Or 4
Make a file read only 1

Back
Top