Select and deselect multiple sheets in Calc

hubertT

I have a multiple sheet Calc document.

I need help please to devise a macro to:-
(a) select all or a number of the sheets for edit; then
(b) de-select all but the original sheet which was active before the multi-sheet edit.

Thanks in advance.
HubertT, Birmingham, UK

hubertT · Posted: Tue Nov 20, 2007 7:30 am Post subject: Problem solved

In desparation I followed pointers in OOo 2.3 Help in conjunction with OOo 'record macro' and came across the following three 'commands'-

".uno:JumpToNextTableSel"
".uno:JumpToPrevTableSel"
".uno:JumpToTable"

I combined them to resolve my problems. Anyone else having problems is free to compare notes with me via my profile details on the OOo forum.

Regards,
HubertT