The spreadsheet does not appear in that list. The spreadsheet is open. It's the only thing open on my desktop. The spreadsheet does have the cptoa1 macro in it.
This spreadsheet works correctly on my Linux 64-bit machine in OO-2.2.1. I bring it over to my Windows Vista machine and have the problems I have been describing. Strange. - Mark On 7/18/07, Anthony Chilco <[EMAIL PROTECTED]> wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
