Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide and show columns using one control button
Hi.
I am great in excel but not so great in macros I am creating a rperot that has "this year", "plan", and "last year" columns. I want to be able to hide and show specific columns like "this year" by pressing a "hide ty" button and once it is hidden, have that same button now say "show this year" and then show this year columns. I have created two button controled macros to do the above but I want to only have one button that toggles and the text changes from hide to show. I have an example of this that I can send to someone. thank you for your help...I am a rookie! Sub Hide_TY() Range("F:F,I:I").Select Range("I1").Activate Selection.EntireColumn.Hidden = True End Sub Sub unhide_TY() Range("E1:G1,H1:J1").Select Range("H1").Activate Selection.EntireColumn.Hidden = False Range("F10").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show or Hide control characters in a cell (using Excel 2007)... | Excel Discussion (Misc queries) | |||
Command Button to show/hide a different worksheet | Excel Discussion (Misc queries) | |||
hide or show a series with a button | Charts and Charting in Excel | |||
Excel button :: Filter columns by value - possible? Additionally, hide certain columns | Excel Programming | |||
Macro to Hide/Show Columns based on control cell value | Excel Programming |