Disable macro in an open document

users
#1

Does anyone know of a way to disable a macro in a document that has
already been opened? Just to clarify, I don't mean "when opening a
document". After I've opened a document and allowed macros to run, is
there a way to disable them later on, without having to close and
re-open the file? A quick google search didn't answer my question.

Regards
Stephan

#2

As far as I know there is no possibility without having to close and re-open the file
But you can stop a running macro.
Therefore you first have to open the development environment by pressing the Strg+F11 keys.
Then choose the macro you want to stop, and click the edit button.
At the top-bar of the following window there should be a round read button with a X .
Press this button, and the macro should stop immediately.
I think it doesn't matter what macro you choose to edit, because all macros are stoped by Pressing the read button

regards Frieder

#3

I'm sorry I was wrong with the "Strg+F11" keys.
You have to press the "Alt+F11" keys to open the development environment.

But way do you want to disable a macro, after you allowed to run it?

regards
Friedre

#4

Frieder wrote:

As far as I know there is no possibility without having to close and re-open the file

Thanks, that answers my question.

But you can stop a running macro.

Thank you for the advice. I do know how to stop a running macro, but
thanks for giving the suggestion any way (might help someone else on
the mailing list).

But way do you want to disable a macro, after you allowed to run it?

It's not really something that you would normally require, I know
that. It's just that I opened a document with macros in it (which I
had created myself, nothing malicious in there). Some of the macros
that are assigned to events were broken (some syntax errors or
something, long story). Every time I selected a different cell (in
Calc) it tries to execute a macro, which fails with an error. It
annoyed me, and I didn't want to debug that macro at the time. I just
wondered if anyone knew if I could disable the macro without closing
and reopening (more for future reference).

I agree with your sentiment that disabling macros should be done when
opening the file. It is only curiosity that sparked my question, not
a real need.

Thanks for your response.

Regards
Stephan

#5

I have an F11 key, but what is a "Strg" key?

This may be obvious and I'm missing it, a thing I do all too well, or it may be something quite obscure.

Help?

--David

#6

I'm sorry I use a German keyboard Strg is the key at the left bottom of the keyboard. I don't know the english name for that key. Also Strg is the wrong key, as I already said in my last mail.
It hase to be the "Alt" key instead ( between the Windows key and the space key).
Regards
Frieder

#7

Hi David,

> you first have to open the development environment by pressing the
> Strg+F11 keys.

I have an F11 key, but what is a "Strg" key?

This may be obvious and I'm missing it, a thing I do all too well, or it
may be something quite obscure.

on a english/us/[insert other country] the STRG key is called CTRL (for control). I have seen STRG only on German keyboards, and it is essentially a translation.

HTH

Sigrid

#8

Hi,

Sigrid Carrera schrieb:

Hi David,

you first have to open the development environment by pressing
the Strg+F11 keys.

I have an F11 key, but what is a "Strg" key?

This may be obvious and I'm missing it, a thing I do all too well,
or it may be something quite obscure.

on a english/us/[insert other country] the STRG key is called CTRL
(for control). I have seen STRG only on German keyboards, and it is
essentially a translation.

Yes, Strg is abbreviation of German 'Steuerung' and that means the same as English 'control'.

kind regards
Regina

#9

lee <lee@yun.yagibdah.de <mailto:lee%40yun.yagibdah.de>>

>The mailmerge tool requires an address list, which is something I don't
>have and don't want to create in this case.

You can do That with a User-form. But you need some subroutines witch copy the contents from the Text-boxes, List-boxes and Combo-boxes from the User-Form to the right place in the document by pushing a button. And then export the document as a PDF.
If you never worked with macros before it will take you quit a while (more then one day). It's much faster if you create a address-list or -database and use the mailmerge tool. ( and you can use the address-list again.) If you want to try the User-form version have a look to the Basic tutorial on the Wiki first.
http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide
All you need to know for that job you will find in the Wiki, or in the internal help.
And if you need help just send me the document (and an exact explanation) and I will help you.
I think, to write some macros is the best way to learn how to program.

regards Frieder

#10

Frieder <delorfr@googlemail.com> writes:

lee <lee@yun.yagibdah.de <mailto:lee%40yun.yagibdah.de>>

The mailmerge tool requires an address list, which is something I don't
have and don't want to create in this case.

[...]

If you never worked with macros before it will take you quit a while
(more then one day). It's much faster if you create a address-list or
-database and use the mailmerge tool. ( and you can use the
address-list again.)

Yeah, I haven't used any macros or other programming with LO yet. Using
the mailmerge tool might be a lot simpler and faster.

If you want to try the User-form version have a look to the Basic
tutorial on the Wiki first.
http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide All
you need to know for that job you will find in the Wiki, or in the
internal help.

Thanks, I'll check that out --- perhaps it isn't very difficult.

And if you need help just send me the document (and an exact
explanation) and I will help you.

Wow, thanks, that's a very generous offer :slight_smile: I think I need to play some
more with the mailmerge tool first. If that doesn't prove useful, I'll
check out the commandline options and then using forms. That's going to
keep me busy for a while ...

#11

Am 20.06.2011 14:36, Frieder wrote:

As far as I know there is no possibility without having to close and
re-open the file
But you can stop a running macro.
Therefore you first have to open the development environment by pressing
the Strg+F11 keys.

Ctrl+Shift+Q stops a running macro easily. But that was not the question.
Greetings,
Andreas