Google Calendar

Display All Calendars

This is now a published Google Spreadsheet Add-On.  If you have any problems with it please email me.

Google Calendar gives a very neat option called ‘Display only this Calendar.’  What this will do is un-select all calendars except the one that you want to view.  Very cool, especially if you have over 150 calendars built in (like I do).

What isn’t cool is having to re-select all of those 150 calendars, and there is not neat little button to do it built into the calendar.  No worries, Google Apps Script to the rescue!  The code that accomplishes this is below.  I have put it into a spreadsheet I use frequently with a custom menu button that gets the process started.  Enjoy!



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">