Joel de Guzman-3 wrote:
>
> hi i'm using oppen office.org calc version 2.0.3
>
> my problem is how to retrieve previously saved macros... i have already
> tried to save several macros on the same document but it keeps on
> disappearing whenever i open my document when in fact i have already saved
> and clicked the save icon on the tools, macros section.
>
> this so called open office calc of yours is starting to be annoying
> because all my efforts in making such macros always keeps on disappearing
> every time i open my document where i saved my macros.. can you help on
> this problem because i really need to do my work fast ... but this calc is
> preventing me from doing this because as i have said earlier the macros i
> have saved disappears. can you explain what is going on with this calc of
> yours
>
>
Hi. Several users have complained about such a problem. I have not
experienced the problem myself. It seems to have arisen since version
2.0.2, which I have continued to use because of problems associated with
later versions. Macro saving may well be one of those problems but I am
unable to say one way or the other.
You are saving the macros in a document library. A new spreadsheet has a
library but you must first create a module in which to write the macros. I
presume you have done that but I'll go through the steps.
First, there is a shortcut to opening the macro editor which you use for
creating and saving macros. It is hidden. Use Tools >Customise and, if you
want to add the shortcut to your toolbar, select the Toolbars tab. Press
"Add" and, in the next dialogue, select Category "Application" and Function
"Edit Macros". Press Add and Close. The shortcut does not have an icon but
you can add one with "Modify" >"Change icon".
That will open the Editor (also called the Basic IDE) with one mouse click.
Select your document library in the drop-down list on the lower toolbar.
You will find <No Module>. Right-click the bar at the bottom of the screen
and select "Insert >Basic Module". That is where you insert your script.
After inserting script, you need to save it. You are actually saving the
document in the case of a document library.
The editor opens by default with the "Standard" library of "My Macros"
displayed. You may have been saving your macros in that library rather than
a document library.
When you record a macro, you get a dialogue which requires you to give the
macro a name and choose a location to save it. If your document has a
library with a module, the dialogue seems to choose the document's
"Standard" library and "Module 1" by default. If not, it seems to choose
the "Standard" library of "My Macros" by default. I have not paid enough
attention to be more definite. The principle remains the same, however.
You may have been saving to the "My Macros" "Standard" library rather than
to a document library.
"My Macros" refers to libraries which belong to the user and are stored in
the user settings folder. There are other macros libraries which are shared
and they are grouped under a different heading ("OpenOffice.org Macros").
So, you have 3 different types of locations: shared, user and document.
I hope you can find your macros.
--
View this message in context:
http://www.nabble.com/how-to-retrieve-previously-saved-macros-tf3472082.html#a9692603
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
