Ask Your Question


asked 2016-12-11 17:42:29 +0100

hola gravatar image

updated 2016-12-12 18:32:16 +0100

Lupp gravatar image

I want to assign an function and disable context menu for RightClick on the cell.

I just migrate from Excel VBA, in VBA Editor, I can choose the event from drop down menu. How can I do this in Calc BASIC?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2016-12-12 19:51:30 +0100

pierre-yves samyn gravatar image


Since version 5.2 there is simpler: ToolsCustomizeContext MenusMenu (listbox): Cell

See Release notes and this example CellRightClick.ods


edit flag offensive delete link more

answered 2016-12-12 13:05:22 +0100

JohnSUN gravatar image

It seems to me that you are looking this menu HowTo

edit flag offensive delete link more

answered 2016-12-16 01:56:59 +0100

hola gravatar image

Thank you JohnSUN, the sheet Events is what I am looking for.

also thanks pierre-yves samyn show me there other methods to change the Context Menu, I was supring that Libreoffice can do this kind of optimization.

In case someone else having same problem and cant find sheet Event in Context Menu, You can find it from Sheet>Sheet Events...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-12-11 17:42:29 +0100

Seen: 213 times

Last updated: Dec 16 '16