Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Hide Form and Command Buttons until such condition is true? | Excel Discussion (Misc queries) | |||
Hide rows based on a condition | Excel Programming | |||
Hide a row based on one cell's condition | Excel Worksheet Functions | |||
how do you hide a forms command button | Excel Programming | |||
Hide command button on worksheet | Excel Programming |