|
|
#1
10-22-2015, 02:32 AM
|
|||
|
|||
Want to show/hide mutiple grouped coloumns in Excel sheet with a button
Dear Friends
I have a calendar made out on weekly on/off basis. I am working at an offshore location where we work for one week and then go town for one week rest. I need to use a button where if I click "Duty" , ALL and ONLY the duty weeks must show up and if I click "Rest" button, ALL and ONLY Rest weeks must show up in the Excel sheet. I also need that after button brings out the required resuts, the called off coloumns could change color also. If it is possible with a function then I would be very happy as people will not have to enable macros at opening the calendar. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to Hide/Un-hide a worksheet based on cell on another sheet. | easton11 | Excel Programming | 1 | 06-02-2015 12:07 PM |
 Assign macro but hide the button/field
|
trlear | Word VBA | 5 | 02-23-2012 04:35 PM |
|
VBA to show/hide tables
|
ccordner | Word VBA | 2 | 07-04-2011 03:00 AM |
| VBA to show/hide tables | ccordner | Outlook | 0 | 07-01-2011 05:10 AM |
|
Button in hidden section won't hide
|
Joe Patrick | Word | 6 | 06-07-2011 09:31 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode