LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Hiding a Button


Hi,

Just wondering if anyone out there can help?

I have a formula in cell A1 and if this is true it puts a '1' in A1 o
and if false leaves this cell blank.

What I am after is... Should cell A1 contain a number 1 then I want
button to be showing be available to click. However, if this cel
contains anything else I want the button to be hidden.

Is this possible? If so, how?

Many thanks :cool

--
gatesheadthund
-----------------------------------------------------------------------
gatesheadthunde's Profile: http://www.excelforum.com/member.php...fo&userid=1053
View this thread: http://www.excelforum.com/showthread.php?threadid=46631

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hiding cells then a button to show them again [email protected] Excel Discussion (Misc queries) 1 January 23rd 07 06:06 PM
Hiding a button when hiding rows fergusor Excel Discussion (Misc queries) 2 August 10th 06 02:31 PM
hiding forms button bigtonyicu Excel Discussion (Misc queries) 1 August 11th 05 11:00 PM
HIDING A BUTTON Glenn Excel Programming 3 May 10th 05 07:54 PM
Hiding A Sheet Command Button With VBA Minitman[_3_] Excel Programming 2 March 7th 04 01:16 AM


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"