#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
I'm not clear on what you mean about the colours but you can use CustomViews to achieve your primary goal. Simply hide one set of columns, then select View - CustomViews - Add... and save that view. Then show all columns and hide the other set and add another view. You may now switch between the two views as you would like.
|
#3
|
|||
|
|||
Thanks Debaser
Actually by spending some time, I managed to work around my problem. I am happy that being a learner, I managed myself to do what I wanted. If you see the attached file, I do have another question ,I am unable to do: I made the calendar for 7/7 days ON/OFF shown with dropdown list and also to show a full calendar but some guys around me are working on 27/29 days Rota and they are asking me to do the same for them. I am totally blank how to do this? These people come on duty for 27 days and goes for rest for 29 days and they want to get a calendar from me where their duty and rest days must be highlighted in different colors, just like the attached one, made by me. Could you please help? |
#4
|
||||
|
||||
I would I think change the layout like this.
|
#5
|
|||
|
|||
Thanks very much, sir for the help. I could further tune with Excel functions.
|
|
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 |