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: 3
Default How do I hide a command button based on a condition?

Hi everybody,
Nice forum. I have read over the hide command button responces but I
simply cannot follow the advice because I guess its to far over my
head. Can anybody please explain to me how to hide a command button
when a cell ( say E27 ) is 0 but as soon as it turns to 1 (through a
formula) a command button will appear in the sheet and allow a user to
launch a macro to save the data (the button will run a macro that
copies data to a different part of the spreadsheet); after the macro
has run I would like the button to hide again.
I have tried various examples but I guess I am putting the samples in
the wrong places ( modules or microsoft excel objects).
I have spent ~6 hours on this one little issue and it is driving me
crazy.
Thanks for any help,
rattman

p.s. If you write the instructions for a 4th grader maybe I will
understand it? :)

 
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
How to Hide Form and Command Buttons until such condition is true? ash3154 Excel Discussion (Misc queries) 0 September 2nd 09 12:37 AM
Hide rows based on a condition KimberlyH Excel Programming 2 March 29th 06 09:03 PM
Hide a row based on one cell's condition Brian Excel Worksheet Functions 1 March 19th 05 11:57 AM
how do you hide a forms command button Paul James[_3_] Excel Programming 4 September 5th 03 06:18 PM
Hide command button on worksheet Mohair Excel Programming 3 July 14th 03 11:06 PM


All times are GMT +1. The time now is 09:47 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"