I am writing a macro that is supposed to work on any spreadsheet. It will,
when I'm done, be able to work on the current selection OR on the whole
spreadsheet. The user can select that in a small dialog with two
radiobuttons.
I understand that ThisComponent.CurrentSelection is relevant for the first
case, and I already finished that part of the macro, but I can't find a
way that will work in the second case, that is on the currently selected
spreadsheet.
ThisComponent.Sheets.getByName("Sheet1") is useless, since the name of the
spreadsheet could be anything.
ThisComponent.Sheets.getByIndex(0) is also useless, since the macro can
not be sure that the user want to work with that spreadsheet.
I hoped to find something like ThisComponent.Sheets.getCurrentSheet, but
that one does not exist, does it? I couldn't find it anyway.
So obviously I am not on the right track here. Can someone point me to the
right direction here?
I just want the macro to work on the currently selected spreadsheet, no
matter what the user highlighted or not.
Anyone? Please?
Best regards
--
Johnny
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
