Maybe you could use a worksheet_change event or worksheet_Calculate.
It would depend on how that cell changes (by formula or by typing) and what kind
of button it is. (Is it an optionbutton from the Forms toolbar or an
optionbutton from the control toolbox toolbar--or is it a button from the Forms
toolbar or a commandbutton from the control toolbox toolbar?)
Steve wrote:
Hello!
I have a button that i want to be hidden unless a certain cell has a
certain value.
Any ideas?
Thanks
Steve
---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080114-1, 14/01/2008
Tested on: 14/01/2008 16:05:29
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com
--
Dave Peterson