PDA

View Full Version : Making command buttons visible



pingwin77
02-04-2009, 03:12 PM
I have a few buttons on a sheet in my workbook called "Data30 - Dev"

On that sheet there is a button that makes the visibility of all the buttons, including itself, set to FALSE and dissapear. I need a button on a different sheet that can be clicked to make all of the buttons visible again incase there needs to be some changes.

how do I change the visibility from false to true for a command button on sheet "Data30 - Dev"?

Thanks!

Bob Phillips
02-04-2009, 03:51 PM
worksheets("Data30 - Dev").buttons("Button 1").visible=true