[libreoffice-users] Macros don't run
If you have a macro assigned to a button in calc where there is only one sheet it works If calc has lots of sheets the macro doesn't run. Do I need to tell the macro which sheet it should be running on somehow Ta M -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macros don't run
I think I may have sussed this one Ta M _ From: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info] To: users@global.libreoffice.org Sent: Thu, 07 Mar 2013 12:18:30 + Subject: [libreoffice-users] Macros don't run If you have a macro assigned to a button in calc where there is only one sheet it works If calc has lots of sheets the macro doesn't run. Do I need to tell the macro which sheet it should be running on somehow Ta M -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macros don't run
Does that mean that you have solved your problem / answered your own question? On 03/07/2013 08:39 AM, Malcolm Moore wrote: I think I may have sussed this one Ta M _ From: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info] To: users@global.libreoffice.org Sent: Thu, 07 Mar 2013 12:18:30 + Subject: [libreoffice-users] Macros don't run If you have a macro assigned to a button in calc where there is only one sheet it works If calc has lots of sheets the macro doesn't run. Do I need to tell the macro which sheet it should be running on somehow Ta M -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macros don't run
I thought I had but it seems not If you recorded a calc macro in 3.5.4 and then open the same spreadsheet in 4.0.n the macro isn't there .. or at least I can't find them. Anyone got any ideas Ta M _ From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] To: users@global.libreoffice.org Sent: Sat, 09 Mar 2013 05:45:48 + Subject: Re: [libreoffice-users] Macros don't run Does that mean that you have solved your problem / answered your own question? On 03/07/2013 08:39 AM, Malcolm Moore wrote: > I think I may have sussed this one > > > Ta > > > M > >_ > From: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info] > To: users@global.libreoffice.org > Sent: Thu, 07 Mar 2013 12:18:30 +0000 > Subject: [libreoffice-users] Macros don't run > > If you have a macro assigned to a button in calc where there is only one > sheet it works > If calc has lots of sheets the macro doesn't run. Do I need to tell the macro > which sheet > it should be running on somehow > > > Ta > > > M > -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
off-list Re: [libreoffice-users] Macros don't run
Hi :) Lol, i was going to ask that! :) Reminds me of the story of the Cambridge Maths Lecturer that at the beginning of 1 term wrote on blackboard "It is obvious that" ... then paused and looked at the board, then at his chalk, then back at his notes and back at the board again and then just walked out the room leaving all the students wondering wtf was going on. The next week they arrived to find a note on the lecture halls door saying the lecture had been postponed. Same thing the week after and the week after that. On the 5th week they arrived to find the professor waiting and he wrote on the board "It IS obvious that" ... Regards from Tom :) > > From: Andrew Douglas Pitonyak >To: users@global.libreoffice.org >Sent: Saturday, 9 March 2013, 5:45 >Subject: Re: [libreoffice-users] Macros don't run > >Does that mean that you have solved your problem / answered your own >question? > >On 03/07/2013 08:39 AM, Malcolm Moore wrote: >> I think I may have sussed this one >> >> >> Ta >> >> >> M >> >> _ >> From: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info] >> To: users@global.libreoffice.org >> Sent: Thu, 07 Mar 2013 12:18:30 + >> Subject: [libreoffice-users] Macros don't run >> >> If you have a macro assigned to a button in calc where there is only one >> sheet it works >> If calc has lots of sheets the macro doesn't run. Do I need to tell the >> macro which sheet >> it should be running on somehow >> >> >> Ta >> >> >> M >> > >-- >Andrew Pitonyak >My Macro Document: http://www.pitonyak.org/AndrewMacro.odt >Info: http://www.pitonyak.org/oo.php > > >-- >For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org >Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >List archive: http://listarchives.libreoffice.org/global/users/ >All messages sent to this list will be publicly archived and cannot be deleted > > > > -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted