TerryJ wrote:
Mark Knecht wrote:
Hi Terry,
1) I have an OO spreadsheet on one machine. It's called ibd100.ods.
When I use this spreadsheet on this specific machine the macros work.
2) When I look at Tools->Macros->Organize Macros->OpenOffice.org Basic
I see the macro existing under "My Mac
Mark Knecht wrote:
>
> Hi Terry,
>
>
> 1) I have an OO spreadsheet on one machine. It's called ibd100.ods.
> When I use this spreadsheet on this specific machine the macros work.
>
> 2) When I look at Tools->Macros->Organize Macros->OpenOffice.org Basic
> I see the macro existing under "My Ma
Hi Mark,
That is the problem. Any macros in 'My Macros' exist in your application
data only and not any particular spreadsheet. If you're here:
'Tools->Macros->Organize Macros->OpenOffice.org Basic'
I see the macro existing under "My Macros->Standard->Module 1" named
cptoa1.
Click the 'Oragniz
Hi Terry,
Thanks for the response. Sorry for my late reply.
I am still unable to make this work.
1) I have an OO spreadsheet on one machine. It's called ibd100.ods.
When I use this spreadsheet on this specific machine the macros work.
2) When I look at Tools->Macros->Organize Macros->OpenOf
Are you using the .ods format? Macros would not, I think, be converted to
the .xls format.
Mark Knecht wrote:
>
> Hi Anthony,
>The macro was developed on the first machine and in the spreadsheet
> that I wanted to use it in. That spreadsheet should (I think) already
> have the macro in it,
Hi Anthony,
The macro was developed on the first machine and in the spreadsheet
that I wanted to use it in. That spreadsheet should (I think) already
have the macro in it, shouldn't it?
However when I move that spreadsheet to a second machine I don't
see the macro in the spreadsheet on the se
Hi Mark,
On the PC where the macros work, go to the organize macros dialogue,
click the 'Organizer' button and select the 'Libraries' tab. Find the
macro, select it and click the 'export' button. Select the spreadsheet
that you want them macro in, then click the import button. Import the
libra
Hello,
I have a spreadsheet that has some conditional formatting macros in
it. If I email this spreadsheet to myself and then download it on a
new PC it seems the macros either aren't in the spreadsheet or aren't
activated.
When I look in Tools-Macros->Organize Macros->Openoffice.org Basic
on