OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Select and deselect multiple sheets in Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
hubertT
Power User
Power User


Joined: 03 Apr 2007
Posts: 52
Location: Birmingham, UK

PostPosted: Tue Nov 20, 2007 3:39 am    Post subject: Select and deselect multiple sheets in Calc Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
hubertT
Power User
Power User


Joined: 03 Apr 2007
Posts: 52
Location: Birmingham, UK

PostPosted: Tue Nov 20, 2007 7:30 am    Post subject: Problem solved Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group