Hi Andrew, Thanks for responding. On 7/18/07, Andrew Douglas Pitonyak <[EMAIL PROTECTED]> wrote:
Mark Knecht wrote:
<SNIP>
> > 1) Does the key assignment have to redone for every machine the > spreadsheet is copied to or have I done something wrong in the way I > assigned it on the first machine?
I need to check, but usually, a key assignment is specific to the machine on which it is made (meaning I do not remember if you can assign a key for a specific document). You should know how the key is assigned when you make the assignment.
OK, but if I was writing a standard spreadsheet for, let's say, a group of office workers, and that spreadsheet had macros saved in it, it would seem that every office worker would have to enter the key assignments to get the macros to work? I trade stocks for a living and am part of a small group of traders that work together. I've built a OO spreadsheet with some macros that I want to give my trading partners to use and improve. Will I have to tell them what keys I have the macros assigned to and then they have to make all the same key assignments? To me this is very intuitive but I'm sure I'm missing something obvious.
> 2) I'm not finding any instructions in the help system on the right > way to assign a keyboard combination to a macro. I did this once a > long time ago but am sort of lost. what is the right way to assign a > key combination so that it works on any machine I put the spreadsheet > on?
I discussed this somewhat in the getting started guide for the macro chapter. See Chapter 17 of the getting started guide. http://documentation.openoffice.org/manuals/oooauthors2/index.html I make a quick reference to the correct chapter for this. I do not remember which chapter this is (it might be in the appendix) but I do reference it. The trick is that while assigning keys, macros are shown in the lower left corner, you must scroll all the way to the bottom if I remember correctly. Take a look and post back if you do not find what you need.
Thanks. The documents are helpful but I'm still not finding exactly what I think I need. 1) I choose Tools->Customize and then the Keyboard tab. 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]
