Solved: worksheet buttons

[chungtinhlak]

Hi, I have many buttons in my worksheets and when the user open, they have to enter the password (i use input box for that), if they don't enter the password or enter it wrong, i want visible to be false to all these buttons.

I can't seem to find the name of the buttons. how to I references these button and how do i get to the name. I can only assign a macro to them.

Thanks in advance for your help.

[GTO]

Greetings chungtinhlak,

How did you create the buttons? Or, more accurately, from which toolbar did they come from? The Forms toobar, or the vba toolbar (the Control Toolbox)?

Mark

[Bob Phillips]

Select the button, and you will see its name in the names box at top left.

[chungtinhlak]

ok, so i have 4 buttons (1 - 4) in 4 of my worksheets.

how come this doesn't work,

[VBA]worksheets(1).button4.visible = false[/VBA]

[georgiboy]

If it is a form button then it should be...

[VBA]Sheet1.Shapes("Button 1").Visible = False[/VBA]

If it is an ActiveX command button then it should be...

[VBA]Sheet1.CommandButton1.Visible = False[/VBA]

Hope this helps.

[chungtinhlak]

thanks, that really help.

[Bob Phillips]

If the are forms toolbar buttons, you van use

[vba]

Worksheets("Sheet1").Buttons("Button 1").Visible = False
[/vba]