Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide or Unhide certain columns based on a cell value
Hello All
I have a worksheet which calculates payback percentages for Slot machines, based on how many coins a person plays. Since machines vary in the amount of coins they are allowed to play, I have the sheet set up from one coin up to five coins. On the sheet, if they enter the amount of coins, it should hide the columns that are not needed... eg: If it is 3 coin machine, it will hide the calculation columns for the fourth and fifth coin. If, after that, they change the number to 2 coins, it should hide the third coin calculation column, and so on. I tried achieving this with a Case... Select approach, but I have having no luck at all. If anyone has some sort of basic code that hides a column in the same sheet, based on a numeric input in a cell on that same sheet, please help. Thank you for your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide or unhide sheets based on cell | Excel Discussion (Misc queries) | |||
PROBLEM: hide/unhide worksheets based on cell value change | Excel Programming | |||
Hide or Unhide Column Based on Cell Value | Excel Programming | |||
Hide/Unhide column based on cell value | Excel Programming | |||
Hide/unhide sheet macro based on cell calculation | Excel Programming |