Stephan G.-2 wrote: > > <snip> > I have a spreadsheet in which there is a macro which is assigned to the > keystroke "Ctrl-Z" in Microsoft Office. > <snip> > > However, I can't figure out how to assign the macro to the keystroke > <ctrl-Z>. I want this keyboard assignment to be made ONLY in the actual > spreadsheet document itself, which is also where the macro is stored. > > The help system says that if I go: > > Tools->Macros->Organize_Macros->OpenOffice_Basic->Assign... > > I should get the "Customize" window complete with its four tabs of > Menus, Keyboard, Toolbars, and Events. I only get three tabs, however, > the "Keyboard" tab is missing when I get to the Customize window through > the tools menu as described above. >
That's correct. IIRC, you could use the Organiser in the 1.1.x series but it has mysteriously vanished. > If I get to the customize window this way: > > Tools->Customize... > > I do have all four tabs. However, when I go to the "Keyboard" tab, I > can see no interface for assigning a macro to a keyboard combination, > and I cannot see how to save ANY keyboard assignment only in my > document. It seems like even if I could make a keyboard assignment, it > would have to be universal to all spreadsheets. > > I am sure I am missing something here. > > Any advice from those who have been at this longer? > > -stephan golux > > Possibly another mysterious disappearance. It is not possible to assign a keyboard shortcut to a document macro after the document has been closed and re-opened. See http://qa.openoffice.org/issues/show_bug.cgi?id=56351 (unconfirmed). You can assign a menu command or, strangely, a toolbar icon. If you want to use a keyboard shortcut, you will have to place the macro in a "My Macros" library. Use the organiser to add a module to "Standard" or to create another library. -- View this message in context: http://www.nabble.com/How-to-assign-Macros-to-Keyboard-shortcuts-in-OO-2.1-Calc--tf3460393.html#a9656330 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
