If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Macros Stop Working
Anyone have any idea why all of a sudden macros would stop working in the
middle of a slide show presentation. Using PP2007. The macros start out fine but halfway through the slide show they just quit working and the user needs to use the esc to exit. Otherwise it just sits there. -- Wi11y13 |
#2
|
|||
|
|||
Macros Stop Working
On 12/8/09 10:13 AM, in article
, "Wi11y13" wrote: Anyone have any idea why all of a sudden macros would stop working in the middle of a slide show presentation. Using PP2007. The macros start out fine but halfway through the slide show they just quit working and the user needs to use the esc to exit. Otherwise it just sits there. Does this happen at the same place every time? Does this happen with all users or just one user in particular? --David -- David M. Marcovitz Author of _Powerful PowerPoint for Educators_ http://www.PowerfulPowerPoint.com/ Microsoft PowerPoint MVP Associate Professor, Loyola University Maryland |
#3
|
|||
|
|||
Macros Stop Working
What do the macros do? Maybe you can post the code?
-- john ATSIGN PPTAlchemy.co.uk Free PPT Hints, Tips and Tutorials http://www.pptalchemy.co.uk/powerpoi...tutorials.html "Wi11y13" wrote: Anyone have any idea why all of a sudden macros would stop working in the middle of a slide show presentation. Using PP2007. The macros start out fine but halfway through the slide show they just quit working and the user needs to use the esc to exit. Otherwise it just sits there. -- Wi11y13 |
#4
|
|||
|
|||
Macros Stop Working
pretty simple really - one sets a string value in a variable and then "goes
to" another slide. The other one is an exit button. The code is included below. The variables are actually define as "Public area3 As String", etc. Sub hr() area3 = "FSRF03 - Credit Agency Reports" ActivePresentation.SlideShowWindow.View.GotoSlide (79) End Sub Sub ExitAllShows() Application.Quit End Sub Once on the slide that has both of these macros within it, nothing works. There are also other buttons that the user could click on but nothing works when arriving at this slide. The user must hit the esc to get out of it. Macros and transitions seem to work on prior slides though. Very strange.... Is there maybe a known problem that SP2 might fix? -- Wi11y13 "John Wilson" wrote: What do the macros do? Maybe you can post the code? -- john ATSIGN PPTAlchemy.co.uk Free PPT Hints, Tips and Tutorials http://www.pptalchemy.co.uk/powerpoi...tutorials.html "Wi11y13" wrote: Anyone have any idea why all of a sudden macros would stop working in the middle of a slide show presentation. Using PP2007. The macros start out fine but halfway through the slide show they just quit working and the user needs to use the esc to exit. Otherwise it just sits there. -- Wi11y13 |
#5
|
|||
|
|||
Macros Stop Working
If it helps (or hurts) the client is running Vista....
-- Wi11y13 "John Wilson" wrote: What do the macros do? Maybe you can post the code? -- john ATSIGN PPTAlchemy.co.uk Free PPT Hints, Tips and Tutorials http://www.pptalchemy.co.uk/powerpoi...tutorials.html "Wi11y13" wrote: Anyone have any idea why all of a sudden macros would stop working in the middle of a slide show presentation. Using PP2007. The macros start out fine but halfway through the slide show they just quit working and the user needs to use the esc to exit. Otherwise it just sits there. -- Wi11y13 |
#6
|
|||
|
|||
Macros Stop Working
ok - upon further testing it seems that not only is the client running Vista,
but the previous macros are not working at all as first thought - JUST the slide transitions. -- Wi11y13 "John Wilson" wrote: What do the macros do? Maybe you can post the code? -- john ATSIGN PPTAlchemy.co.uk Free PPT Hints, Tips and Tutorials http://www.pptalchemy.co.uk/powerpoi...tutorials.html "Wi11y13" wrote: Anyone have any idea why all of a sudden macros would stop working in the middle of a slide show presentation. Using PP2007. The macros start out fine but halfway through the slide show they just quit working and the user needs to use the esc to exit. Otherwise it just sits there. -- Wi11y13 |
#7
|
|||
|
|||
Macros Stop Working
On 12/8/09 4:32 PM, in article
, "Wi11y13" wrote: ok - upon further testing it seems that not only is the client running Vista, but the previous macros are not working at all as first thought - JUST the slide transitions. Well, that makes a lot more sense. Macros must be off for that user. -- David M. Marcovitz Author of _Powerful PowerPoint for Educators_ http://www.PowerfulPowerPoint.com/ Microsoft PowerPoint MVP Associate Professor, Loyola University Maryland |
#8
|
|||
|
|||
Macros Stop Working
Two possibilities:
1. as David says, the user may have Macros disabled on that machine. -or- 2. The Macro may encounter an error that is not correctly handled or when VBA gets confused, it simple stops responding. The possibilities are that the variable may not have been correctly defined or there may not be a slide 79 or the slide show may not be active. All unlikely, agreed, but this is a behavior that I have run across before (especially if you have set up an On Error - Stop type of trap anywhere in your code). Bill Dilworth "David Marcovitz" wrote in message ... On 12/8/09 4:32 PM, in article , "Wi11y13" wrote: ok - upon further testing it seems that not only is the client running Vista, but the previous macros are not working at all as first thought - JUST the slide transitions. Well, that makes a lot more sense. Macros must be off for that user. -- David M. Marcovitz Author of _Powerful PowerPoint for Educators_ http://www.PowerfulPowerPoint.com/ Microsoft PowerPoint MVP Associate Professor, Loyola University Maryland |
#9
|
|||
|
|||
Macros Stop Working
It happens for any macro in this slide show when executed on the Vista
machine. We have only tried it on 1 Vista but it seems to work ok in XP. On the Vista machine, the user answered yes to the security question that comes up and states "macros are disabled would you like to enable". She "clicked" on the enable button. In XP if the macros are disabled, then the Powerpoint transitions do not even work at all. In this case the transitions work ok but none of the macros work - on any page. If you attempt a macro nothing happens but then hit a transition on the same page and that transition works. There is no "trap" - I would not know how to do that :-) I know very little about Vista but I am wondering if there is a Vista macro inhibitor that "trumps" the Powerpoint security message that is displayed and answered. -- Wi11y13 "Bill Dilworth" wrote: Two possibilities: 1. as David says, the user may have Macros disabled on that machine. -or- 2. The Macro may encounter an error that is not correctly handled or when VBA gets confused, it simple stops responding. The possibilities are that the variable may not have been correctly defined or there may not be a slide 79 or the slide show may not be active. All unlikely, agreed, but this is a behavior that I have run across before (especially if you have set up an On Error - Stop type of trap anywhere in your code). Bill Dilworth "David Marcovitz" wrote in message ... On 12/8/09 4:32 PM, in article , "Wi11y13" wrote: ok - upon further testing it seems that not only is the client running Vista, but the previous macros are not working at all as first thought - JUST the slide transitions. Well, that makes a lot more sense. Macros must be off for that user. -- David M. Marcovitz Author of _Powerful PowerPoint for Educators_ http://www.PowerfulPowerPoint.com/ Microsoft PowerPoint MVP Associate Professor, Loyola University Maryland . |
Thread Tools | |
Display Modes | |
|
|