Ask Your Question
0

LO 4.1, Windows. Calc - how to copy sheet and its macros? [closed]

asked 2014-06-08 23:29:24 +0200

hubris gravatar image

updated 2015-09-05 01:05:45 +0200

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 00:22:05.453176

1 Answer

Sort by » oldest newest most voted
0

answered 2014-06-09 00:03:56 +0200

Lewis Cowles gravatar image

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)

edit flag offensive delete link more

Comments

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.

hubris gravatar imagehubris ( 2014-06-13 00:05:09 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-06-08 23:29:24 +0200

Seen: 330 times

Last updated: Jun 09 '14