Hi,

I have a spreadsheet that has a number of command buttons on it and they all have macro's assigned to them. The macro simply puts the number "1" in a specific cell.

What i want is for each button to be hidden as soon as there is a "1" in that specific cell.

And then when i run a separate macro later to clear the "1" i want the buttons to re-appear.

Is this possible?

Thanks

James Ryan