Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle Hide/Show
Hi Alan,
Here you go Columns("C:G").Hidden = Not Columns("C:G").Hidden -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Alan" wrote in message ... Greetings, I would like button that the first time its clicked, will hide columns C:G and when clicked the next time will show the same columns. I can write the code to separately hide or show but I dont know how to combine them to toggle when the button is clicked. All help is greatly appreciated! Alan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toggle show / hide group outline symbols with shortcut | Excel Discussion (Misc queries) | |||
Hide data series in chart - toggle on and off | Charts and Charting in Excel | |||
How DO I get the bold face toggle to show | New Users to Excel | |||
show hide row if | Excel Discussion (Misc queries) | |||
using a toggle button to show or hide information in several cells | Excel Worksheet Functions |