We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc assign macro to menu [closed]

asked 2012-10-16 23:14:35 +0200

vbas96 gravatar image

updated 2015-10-24 03:08:19 +0200

Alex Kemp gravatar image

I've created a macro and stored it in a LibreOffice v. Calc module (OS - Windows Vista). I have a Menu for the macro created in the document, but cannot successfully "assign" the macro to the menu. The Path I use is >Tools >Customize >Menus. From the dropdown I select the menu where I want the macro to reside, and click >Add. The list of categories appears, and I expand +Libre Office Macros. The resulting choices are +My Macros, +LibreOffice Macros, and +"MyCalc".ods. The problem occurs when I try to select (e.g.) "+My Macros" to show the Module (and allow MacroName selection). The window goes to the "Not Responding" coloration, and I get an MS Windows dialog informing me "A problem caused the program to stop working correctly...." When I restart LibreOffice Calc, recovery is required. The outcome is the same if I store the macro in +My Macros >ModuleName or in +"MyCalc".ods >ModuleName. Suggestions please! It's a macro I would use frequently, and need the convenience of menu access.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-24 03:08:50.073791

1 Answer

Sort by » oldest newest most voted

answered 2013-02-26 21:04:45 +0200

razon_22 gravatar image

Update to LibreOffice 4.0 and try assigning the macro again. This should fix your problem.

edit flag offensive delete link more

Question Tools


Asked: 2012-10-16 23:14:35 +0200

Seen: 1,083 times

Last updated: Feb 26 '13