Buttons

[Fire_Chief]

I have a button on my sheet that I made with the Forms Toolbar.
I would like to be able to enable and disable it with another button which I have password protected.

I can make the buttons and write all other code needed but I don't know how to write the code that will disable the button.
I have tried:

Button1.enable = False and a couple others but nothing seems to work.

Thank You

marty

 

[bjurney]

You are close, it would be:

commandbutton1.Enabled = false

 

[Fire_Chief]

I tried that and it doesn't work. Could it be I used the wrong toolbar ( I used the forms toolbar) to create the button.

 

[bjurney]

I would use the Visual Basic Toolbars to add this button. The buttons look the same and for the most part act the same.

 

[Fire_Chief]

By Visual Basic Toolbars are you referring to the toolbar you would get by going to
View.....Toolbars.....Control Toolbar

 

[bjurney]

Yes I am. Sorry about that.

 

[Fire_Chief]

No problem

Sure wish I knew the difference between the two.

 

[bjurney]

I found this website helpful in descibing the diffrence between the two

http://spreadsheetpage.com/index.php/tip/using_controls_on_worksheets/