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.
Right-click on the sheet and use the “Move/Copy Sheet…” item in the list to clone your sheet (All sub-sheet references in formulae will be preserved to the new sheet and all cross-sheet references should still reference the same sheet)
Thanks but it’s this doesn’t copy the sheet event (macro) from the original sheet. In the newly copied sheet I have to right-click → ‘Sheet events’ and then add my macro again. This is the issue I’m having.