Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide non-contiguous cells
I assume this needs to be done using VBA, but I'm willing to do whatever it
takes. I have a rather large spreadsheet and I want to enable the user to select between 2008 data, 2009 data, or show all. I've done this with a macro by hiding and unhiding then assigning the macro to the buttons, but when I click either of the first ones the buttons move to the left edge of the spreadsheet, and when I open it back up again they're all messed up. The columns I need to show are non next to each other, so I can't use the grouping feature (I don't think). Does anybody have an idea of how to proceed? I'd appreciate the advice and help. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200808/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide non-contiguous cells
So the problem is that your buttons move when you hide rows?
If so, right click on them and go into Format Control and on the Properties tab change to "Don't move or size with cells" -- Jim "lonnierudd via OfficeKB.com" <u11209@uwe wrote in message news:87ff3187388e2@uwe... |I assume this needs to be done using VBA, but I'm willing to do whatever it | takes. I have a rather large spreadsheet and I want to enable the user to | select between 2008 data, 2009 data, or show all. I've done this with a macro | by hiding and unhiding then assigning the macro to the buttons, but when I | click either of the first ones the buttons move to the left edge of the | spreadsheet, and when I open it back up again they're all messed up. The | columns I need to show are non next to each other, so I can't use the | grouping feature (I don't think). Does anybody have an idea of how to proceed? | I'd appreciate the advice and help. | | -- | Message posted via OfficeKB.com | http://www.officekb.com/Uwe/Forums.a...mming/200808/1 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non-contiguous cells | Excel Discussion (Misc queries) | |||
Copy and Paste LAST ROW of data: non-contiguous Row, contiguous Column | Excel Programming | |||
counting cells that are 0 in a range of non-contiguous cells | Excel Worksheet Functions | |||
How do I count non-contiguous cells? | Excel Worksheet Functions | |||
Hide non-contiguous columns | Excel Programming |