In Calc, I have a new sheet each month. The sheet has an event triggered on sheet activation, and this event calls a macro.
On each new month, I copy the previous month to the new sheet/month (and clear the data so I have in effect a clear template), which copies the contents of the previous sheet, but not the sheet event.
Is it possible to do this?
Thanks.