[SOLVED] Macro Removal help

Creating a macro - Writing a Script - Using the API

[SOLVED] Macro Removal help

Postby pherriot » Thu Jul 11, 2019 10:49 am

Hi everyone.

Im having real problems removing a previous attempt at Macro creation.

Please see cell A2 for the image linked to a Macro which no longer exists and cannot be removed (apparently).
Image

Any help is appreciated.
Cheers.
Paul.
Attachments
test.ods
(56.08 KiB) Downloaded 14 times
Captura1.JPG
Captura1.JPG (13.99 KiB) Viewed 298 times
Last edited by robleyd on Thu Jul 11, 2019 1:53 pm, edited 2 times in total.
Reason: Add green tick
OpenOffice 3.1 on Windows Vista
pherriot
 
Posts: 54
Joined: Wed Mar 27, 2019 1:06 pm

Re: Macro Removal help

Postby RoryOF » Thu Jul 11, 2019 11:11 am

Remove the macro by /Tools /Macros /Organize Macros /OpenOffice Basic, then select the macro and press the Delete button.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29559
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Macro Removal help

Postby pherriot » Thu Jul 11, 2019 11:29 am

That doesnt work......
OpenOffice 3.1 on Windows Vista
pherriot
 
Posts: 54
Joined: Wed Mar 27, 2019 1:06 pm

Re: Macro Removal help

Postby RoryOF » Thu Jul 11, 2019 11:32 am

More information, please. Where did the macro come from? In what language is it written?
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29559
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Macro Removal help

Postby pherriot » Thu Jul 11, 2019 11:35 am

It was recorded, i.e. simple recording of the steps taken (select column B and remove agent numbers).

language was (I guess) basic .
OpenOffice 3.1 on Windows Vista
pherriot
 
Posts: 54
Joined: Wed Mar 27, 2019 1:06 pm

Re: Macro Removal help

Postby JeJe » Thu Jul 11, 2019 12:02 pm

The macro no longer exists but is called by the cell. If you use Edit / delete content / delete all you'll clear this - though I had to select both A1 and A2 first... maybe someone who knows more than me about spreadsheets can do it without also selecting A1.

Edit: correction called by the image not cell.
Openoffice 4.1.2
Windows 8
JeJe
Volunteer
 
Posts: 580
Joined: Wed Mar 09, 2016 2:40 pm

Re: Macro Removal help

Postby pherriot » Thu Jul 11, 2019 12:51 pm

JeJe.
That worked a treat, maybe I had inadvertantley attached it to A1.

Ill remember that one.
Thanks buddy
OpenOffice 3.1 on Windows Vista
pherriot
 
Posts: 54
Joined: Wed Mar 27, 2019 1:06 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 5 guests