Defaulting a multi box date value when opening a document
I would like to default a multi box date value field to the weekstart of this week. I've looked into using a macro from OnActivateSheet Trigger but unable to get the syntax correct, and thinking there must be an easier way. Attached is a screen shot of the multi box properties, and a portion of the screen showing the two values. I'd like to default to the start of this week (07/14/2014) when opening the document.