Hi Mark,
Your spreadsheet, ibd100, should appear in the list along with 'user'
and 'share'. If it's not there, either the spreadsheet is not open or it
doesn't have any macros in it. It's possible there are other reasons for
not being there. It appears that having unsaved modifications prevents
the spreadsheet from being in the list. I recorded a small macro in a
test spreadsheet and it appears in the list. If I close the spreadsheet
and reload it, it does not appear until I make a change and save the
spreadsheet. Go figure.
tc
Mark Knecht wrote:
Anthony,
Thanks for the help.
I am in my spreadsheet which has the macro. I see it in
Tools->Macros->Organize Macros->OpenOffice.org Basic... and then
looking at the name of the spreadsheet:
ibd100->Standard->cptoa1
(NOTE: It would be FAR more intuitive to me if I could assign the key
here using the assign button but it doesn't seem to allow that. Why?)
OK, so I now close all of this and go to Tools->Customize and the
Keybord tab. OpenOffice.org Macros shows two sub headings - '+user'
and '+share'. I expand both of these and do not find my macro name
anywhere yet.
Much earlier on I had the macro on the machine and not in the
spreadsheet. I believe you helped me see that if I wanted to move the
macro with the spreadsheet I had to move it's placement into the
spreadsheet name in the Organize Macros area above. However now I have
the spreadsheet on a different machine and cannot see how to get the
key assigned.
Sorry for my extreme density.
Thanks again,
Mark
On 7/18/07, Anthony Chilco <[EMAIL PROTECTED]> wrote:
Hi Mark,
To assign a macro, you want to select the category 'OpenOffice.org
Macros'. If you have a spreadsheet that contains macros open, that
spreadsheet will appear in the list below the category heading when you
expand it by clicking the plus sign or double-clicking the heading.
tc
Mark Knecht wrote:
<snip>
>
> 2) According to the Getting Start Guide appendix I'm supposed to
> choose a category and a function. When I look in the Category list I
> don't find 'Macros'. The best I find so far is 'BASIC' so I choose
> that and find 'Run Macro' which seems like a good choice.
>
> 3) I do not see my macro's name anywhere yet.
>
> 4) The appendix tells me to choose my key combination so I choose
> Ctrl-Shirt-A.
>
> 5) The appendix say to select modify and OK but I think this is jsut
> going to assign 'Run macro', not 'Run my macro'.
>
> I must be missing where I assign my specific macro.
>
> Thanks,
> Mark
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
