[SOLVED] Macro Removal help

[pherriot]

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).


Any help is appreciated.
Cheers.
Paul.

[RoryOF]

Remove the macro by /Tools /Macros /Organize Macros /OpenOffice Basic, then select the macro and press the Delete button.

[pherriot]

That doesnt work......

[RoryOF]

More information, please. Where did the macro come from? In what language is it written?

[pherriot]

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

language was (I guess) basic .

[JeJe]

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.

[pherriot]

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

Ill remember that one.
Thanks buddy