edit a macro created in a excel sheet

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

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

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

Pansmanser
295 ●42 ●52 ●63

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

Comments

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

Valtergio ( 2020-12-28 14:57:15 +0100 )edit

add a comment

edit a macro created in a excel sheet

1 Answer

Comments

Question Tools

Stats

Related questions

edit a macro created in a excel sheet edit

1 Answer

Comments

Question Tools

Stats

Related questions

edit a macro created in a excel sheet