Ask Your Question
0

MACRO RightClick EVENT

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
1

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

pierre-yves samyn gravatar image

Hi

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

See Release notes and this example CellRightClick.ods

Regards

edit flag offensive delete link more
0

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
0

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

Stats

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

Seen: 213 times

Last updated: Dec 16 '16