OnActivateSheet Trigger to set dates in calendar objects

[#1]

Hi,

My sheets all contain 2 calendar objects for the user to select start and end dates for the charts on the sheet.  Is it possible to set an onActivateSheet trigger  to always set the date to be current month-to-date ,1st of the Current Month to Yesterday?

Thanks in advance.

Brian

[jerrysvensson]

Not if you are using Ajax (Webview) as client. Since OnActiveSheet does not work in Ajax.