change control properties according to a cell value
 

Using Excel 2003 I want to make a button control visible/invisible according
to the value in a cell which contains the formula counta(a1:a10). How can I
do this?

change control properties according to a cell value
 

I've worked it out now. I used the worksheet recalculate event to trigger a
macro

"Billums" wrote:

Using Excel 2003 I want to make a button control visible/invisible according
to the value in a cell which contains the formula counta(a1:a10). How can I
do this?