Bug 71562

Summary:	Other: Enhancement – Assigning a macro to an event which is saved with the file
Product:	LibreOffice	Reporter:	Óvári <ovari123>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	bfo.bugmail, robinson.libreoffice
Priority:	medium
Version:	4.1.3.2 release
Hardware:	Other
OS:	Windows (All)
Whiteboard:	BSA
Crash report or crash signature:		Regression By:

Description Óvári 2013-11-13 07:42:00 UTC

Event-Driven Macros (https://help.libreoffice.org/Basic/Event-Driven_Macros) discuss how to assign a macro to an event (eg. Print Document) application wide.

It would be appreciated if macros could be saved with the spreadsheet file and only seen and run with this file and no other files.

Another way of stating this is: How does one assign a macro to an event (eg. Print Document) which is only assigned to a LibreOffice Calc spreadsheet file, not the LibreOffice application?

Thanks
Operating System: Windows 7
Version: 4.1.3.2 release

Comment 1 bfoman (inactive) 2013-11-15 20:31:59 UTC

(In reply to comment #0)
> It would be appreciated if macros could be saved with the spreadsheet file
> and only seen and run with this file and no other files.

If you want your macro to be used only with the current spreadsheet, save it under the spreadsheet's name instead of My Macros or LibreOffice Macros libraries.

Comment 2 Robinson Tryon (qubit) 2013-12-22 15:37:37 UTC

(In reply to comment #1)
> (In reply to comment #0)
> > It would be appreciated if macros could be saved with the spreadsheet file
> > and only seen and run with this file and no other files.
> 
> If you want your macro to be used only with the current spreadsheet, save it
> under the spreadsheet's name instead of My Macros or LibreOffice Macros
> libraries.

Resolving as 'WORKSFORME'.

Ovari - Please let us know if you're still experiencing issues saving macros with a particular spreadsheet.