Ask Your Question
0

edit a macro created in a excel sheet

asked 2020-12-28 11:50:14 +0100

Valtergio gravatar image

i have a sheet excel imported, inside that sheet i have some macro, the macro work ok, now i want to edit some macros, in microsoft excel the procedure was: with right mouse button select the macro and choose change or modify macro. with Libreoffice the right button of the mouse does not select / has no effect on the button that activates the macro, if I go to the Macros menu - edit a macro, I don't see the macros in the macro list. what is the procedure to access the macro? Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-12-28 13:16:59 +0100

Pansmanser gravatar image

I take it the macro is connected to a button. To work on the button, choose View-Toolbars-Form_Controls, then click on the design button (a little set-square icon). Now the button is inactive. Double click to open the Control for edit. Under the Events tab, you will find the macro associated with pressing or releasing the button. I have not used excel sheets in calc, but the macro itself should be stored with the other macros. Choose Tools-Macros-Edit_Macros, and look for the Object Catalog (left hand column of the edit macro window) and select your spreadsheet. Somewhere down there I would expect to find the macro connected to the button.

edit flag offensive delete link more

Comments

until "now button is inactive" i am with you, but "double click" on what? on the button double click not have effect.

Valtergio gravatar imageValtergio ( 2020-12-28 14:57:15 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-12-28 11:50:14 +0100

Seen: 22 times

Last updated: Dec 28 '20