This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

SlideShowView.Exit method (PowerPoint)

  • 6 contributors

Ends the specified slide show.

expression . Exit

expression A variable that represents a SlideShowView object.

This example ends the slide show that's running in slide show window one.

SlideShowView Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Was this page helpful?

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback .

Submit and view feedback for

Additional resources

How to use VBA in PowerPoint: A beginner’s guide

  • Written by: Jamie Garroch
  • Categories: PowerPoint productivity , Presentation technology
  • Comments: 45

vba powerpoint exit presentation mode

Here at BrightCarbon we’re always looking for new ways to improve our own PowerPoint productivity and then share that knowledge with the presentation community (that includes you, by the way!). One of the ways we do this is by using VBA code to automate and extend the functionality of PowerPoint. We publish  free PowerPoint VBA code snippets here in our blog for you to use and also offer a PowerPoint automation service . This article explains how to grab the code from our articles and use it in your PowerPoint project, so that you can take your productivity to the next level!

What is VBA?

Visual Basic for Applications (VBA) is a programming environment for Microsoft Office applications. It’s included with your installation of Office by default  ( unless your system administrator has deactivated it ) . PowerPoint VBA provides you with a way to do one of two things   using macros and add-ins:  

  • A utomate  PowerPo int:   If you ever find yourself repeating the same task over and over again, VBA could be your new best friend.  Let’s say you have 100 slides and you need to unhide all hidden objects  across all those slides . That could take you  many  eye-straining minutes, but with a PowerPoint VBA it takes around a  second.
  • E xtend  PowerPoint :   Sometimes PowerPoint doesn’t have the feature you need  to complete your task . As an example, if you end up deleting default layouts from a template, there’s no  easy  way in PowerPoint to get them back. This article includes PowerPoint VBA code to do just that!

How to open the VBE (Visual Basic Editor)

Getting to meet your VBA friend is very simple. With PowerPoint open and at least one presentation file open, press  Alt+F11 * on your keyboard. This will open the VBE (Visual Basic Editor):  

PowerPoint VBE No Modules

*If for some reason Alt+F11 isn’t mapped on your keyboard you can right click anywhere on the ribbon, select  Customize the Ribbon…  and in the window that appears, tick the  Developer Tab  check box over on the right hand side before clicking  OK  to close the window. Now you can click the  Visual Basic  button within this tab:  

PowerPoint Developer Tab Visual Basic

Adding PowerPoint VBA code  

To add some VBA code, you need a container to put it in so go ahead and click  Insert  from the menu and then select  Module :  

PowerPoint VBE Insert Module

You now have a module ready to paste the VBA code into  from one of our blog articles :  

PowerPoint VBE Module Inserted

Copy the VBA code from  the required blog article  by double-clicking on it and then paste it into the  Module1  window above.  Here’s a very simple example of some code  to display a message dialogue :

You should now see something like this:  

PowerPoint VBA

Because this code is just a single  Sub  procedure called  HelloWorld , it’s referred to as a macro.  

Running  the PowerPoint VBA macro  

Now you have the macro in your presentation you can use  Alt+Tab  to return to the more familiar PowerPoint window. From here, the macro can be run by pressing  Alt+F8  on your keyboard  (or b y  clicking the  Macros  button in the Developer tab)  which opens a window containing a list of available macros:  

PowerPoint VBA

Security Soup

The first time you add VBA code to a file, Microsoft assumes that it is safe because you added it. As soon as you save, close and reopen the file, Microsoft doesn’t know that it’s your code so it will disable it by default. You can tell the Office app to allow your code to run either by signing it with a digital certificate (beyond the scope of this article) or by lowering the security setting for the app. You can do this in PowerPoint by clicking File / Options / Trust Center / Trust Center Settings / Macro Settings and selecting this option shown below:

VBA Macro Settings

Saving your file  

vba powerpoint exit presentation mode

Once you ’ve added  VBA code  to  your presentation, PowerPoint will  ask you to save it as a  pptm  file  (the ‘m’ stands for macro)  instead of the more  familiar  pptx  format .  You can go ahead and do this to  either  keep a n archive  copy of your  code-enabled  project  or   to  create your personal macro library.  

If you want to distribute your  presentation,   it’s advisable to   save  it  using the familiar pptx format so that  your  recipients don’t see lots of verbose  security  messages  when opening  pptm  files!  

Y ou can  make  your file saveable as a standard presentation again  by  right – click ing  on  each   code module in the  project explorer pane , clicking  Remove   ModuleX …   and either click  Yes   (if you want to keep a backup of the modules independently of your presentation)  or  No   when  asked if you want to save the module before removing it :  

vba powerpoint exit presentation mode

Now your presentation doesn’t include any code and you can save it as a pptx file.  

So, there you have it.  You now know how to open the VBE, insert a PowerPoint VBA code module, paste code into it, run the macro and save the file in either pptm  or pptx formats. All you need is a cool macro to make your daily life even easier. Keep checking in with our blog for more useful macros – like this one on restoring default slide master layouts!

Got something extra you’d like PowerPoint to do?

Check out our PowerPoint automation service which provides you with a custom solution to your specific needs.

vba powerpoint exit presentation mode

Jamie Garroch

Principal technical consultant, related articles, how to consistently brand graphs and charts across microsoft office.

  • PowerPoint design / PowerPoint productivity
  • Comments: 1

How do you make sure that your graphs and charts have consistent branding across Excel, PowerPoint and Word? Learn how to create and use custom templates that support your brand identity across Microsoft Office.

vba powerpoint exit presentation mode

Changes to VBA Macro Security in Microsoft 365

  • Presentation technology / Industry insights
  • Comments: 2

You can do some really cool things in Microsoft Office with just a few lines of Visual Basic for Applications (VBA) - from creating your own custom formula in Excel to correcting branded content in PowerPoint to merging address data for a mail campaign in Word. And sometimes you need to share that VBA solution with colleagues and clients, via the Internet. A change that Microsoft rolled out at the end of March 2022 tweaks the process required by Windows users to gain access to this active content.

vba powerpoint exit presentation mode

Protecting your prized PowerPoint content

  • PowerPoint productivity / Presentation technology

Our comprehensive guide to password protecting PowerPoint files so your precious presentations stay just they you made them!

very simple, very explicit, very good help for a beginner vba programmer in powerpoint. Thanks

great resource, thanks. I’ve used VBA for years in MSaccess, and this is a good refresher for me.

I am trying to make a ppt file that loops until stopped. then I save it as a video. the ppt ran and looped continuously. Once recorded as video it stopped looping. do you have code to make ppt work when in video format

Hi Charles. As soon as you export a PowerPoint deck as a video all the PowerPoint functionality is removed as the file is magically transformed into an MP4 file, without VBA (sob sob). The only way to make the video loop is to use the looping feature of your video player.

Yeah, your best off recording a screen capture of the presentation running, then cutting it so it loops perfectly.

You can convert the video into gif file so that it will loop

Hi Jamie, thanks for the clear into, I am very new to this so that really helps. I am trying to develop a VBA macro that looks for the left hand mouse key being pressed and held down for more than two seconds whilst over a shape in slideshow mode. Once this is satisfied (i.e. two second press) for it then to hyperlink or take the user to a specified slide or even the next slide worst case.

I realise there is an automated/ built in feature (Action) that does this type of thing for a mouse click or mouse over but I really need a “long press” to activate if possible.

Any help appreciated.

Hi Simon and thanks for a great question. What you’re looking to do is pretty complex because VBA doesn’t natively support mouse actions in the PowerPoint slide show window. But, it is possible to use a Windows API (hence no Mac compatibility) called GetAsyncKeyState to gain access to mouse button click events. I had a look at this and quickly ran into a brick wall because an action link to a macro in slide show mode (Insert / Action / Mouse Click / Run macro) fires on the mouse up event, not mouse down. That means any corresponding VBA timer code can’t run until after the user releases the button and hence too late to detect if it was held down for two seconds. Maybe something could be done with the mouse over event to simulate what you need to achieve? Another approach could be to use the mouse down event on an invisible userform although that is also getting very involved with multiple Windows APIs. Depending on what you’re trying to do, you could also start the timer on click one, change the colour of the clicked shape and show countdown text before reverting to the original colour. If the user clicks a second time before the time expires, then the hyperlink is fired.

Valuable app

Hello I have a question:

Private Sub CommandButton2_Click() ActivePresentation.FollowHyperlink _ Address:=”http://192.168.16.49/?OUT1=ON”, _ NewWindow:=False, AddHistory:=False ActivePresentation.SlideShowWindow.View.GotoSlide (2)

Now it opens Chrome. but how can i make it that it opens te address en afther that shut down chrome.

Hi Tom. Your example should open the default browser at the URL specified by the Address parameter. For more information on the FollowHyperlink method, see this Microsoft documentation: https://docs.microsoft.com/en-us/office/vba/api/powerpoint.presentation.followhyperlink

Thank you very much! It’s exactly what I needed.

I have tried using your randomizing macro with a powerpoint – I must be doing something wrong, because it isn’t putting the slides in random order. Please advise! I copied the macro exactly (using cut & paste), and thought I was following all the directions here for how to use it in the powerpoint. But, no random presentation of the slides. Boo hoo!

Hi Marya. Let’s check that VBA is installed and enabled on your machine. Can you add the following macro to the VBE project (just below the existing one) and try to run it from the PowerPoint window using Alt+F8?

Sub CheckVBA() MsgBox “it’s working” End Sub

Make sure the quotes are the straight type.

I am trying to format my title page so that the number displayed is equal to the linked slide and updates automatically wherever the slide is moved. For example “about us” is on slide #5 and linked, so it goes to slide 5 when you click on the word. I need the number (in a separate text box) to update automatically to the slide number location that the link goes to.

Hi Mary and thanks for the question. It looks like you’re interested in some kind of automated agenda slide builder. That’s a fair bit of code to create and quite complex as it needs to handle events from PowerPoint to detect when slides have moved. It could be possible to write a simpler macro which you run manually each time you want to update that title page. You’d need start by finding a way to identify which objects are your numerical indicators. For example, if you named your objects in the selection pane (Alt+F10) “Agenda Link”, then is simple macro could be a starting place for you: Sub UpdateAgendaNumbers() Dim oSld As Slide Dim oShp As Shape Dim LinkedSlideIndex As Long On Error Resume Next For Each oSld In ActivePresentation.Slides For Each oShp In oSld.Shapes If oShp.Name = “Agenda Link” Then If oShp.ActionSettings(ppMouseClick).Action = ppActionHyperlink Then If oShp.HasTextFrame Then LinkedSlideIndex = Split(oShp.ActionSettings(ppMouseClick).Hyperlink.SubAddress, “,”)(1) oShp.TextFrame.TextRange.Text = LinkedSlideIndex End If End If End If Next Next End Sub

Great wealth of information. Have never used macros before but was looking to use them to help with this situation. At work we use Work Orders (created in Power Point) and are looking to include a sequential number to them (print 50-100 copies of one slide with the numbers) and if possible would like the number to continue from the last printed number…been trying to find some code to help but not having much luck possible partly due to being new to macros

That’s definitely something we could help design for you Joshua. If you’d like to discuss further, please click the Contact button at the top of this page.

I tried this changing the font color of text within the textbox. I used this to change the font color on a mouse over:

Public Sub GraphicHover(ByRef oGraphic As Shape)

oGraphic.TextFrame.TextRange.Font.Color.RGB = RGB(0, 130, 202)

and it works just fine. But, when I move the mouse off the text box, onto the invisible rectangle with this code attached to the mouseover event, it doesn’t change the text color back to it’s original color and remains the color I changed it to mentioned above. I know the mouseover event is being triggered because I checked “Highlight when mouse over” and I am seeing the highlight on the invisible rectangle:

Public Sub ResetGraphicHover(ByRef oCover As Shape) Dim oSld As Slide Dim oShp As Shape Set oSld = oCover.Parent For Each oShp In oSld.Shapes With oShp.TextFrame.TextRange.Font.Color If .RGB = RGB(0, 130, 202) Then .RGB = RGB(121, 135, 156) End With Next End Sub

Any clue where my ResetGraphicHover is failing?

Hi Dave. I took your code and it works for me. You could add a debug line after the For Each… line in the rest macro to check that (a) it’s firing and (b) which shapes are being looked at on your slide. To do that, add this:

Debug.Print oShp.Name

After you run the slide show, check the output in the VBE Immediate pane (Ctrl+G to toggle it).

Hi I am creating an interactive game (matching cards or concentration) in PowerPoint. If the 2 cards match, I need a pop-up text box to appear. If the 2 cards do not match, I need a sound to play.

I understand I need programming to make this happen. Please help or give alternative ways to achieve this. Thanks.

Hi Tammy. Have a look at this article which will help you: https://www.brightcarbon.com/blog/powerpoint-memory-game/

Hi Producer I will like to get comments on macros you can make available to me. Beautiful. I am using this approach frequently to make offline projects. Thanks. S. Fas

Excellent!!! Thank you!

You’re more than welcome Nataša!

Thank you! Is there any option to replace a font in the entire presentation for a specific character. Let’s say, I would like to change font only for dots in the deck but I would like to keep the rest in the original font. Any idea please? Thank you so much!

Hi Jan. You might be able to use the Replace Fonts feature found in the Home tab of PowerPoint under the Replace menu at the far end of the ribbon. If you need to use VBA then set up a nested loop to iterate all shapes within all slides and then use the oShp.TextFrame2.TextRange.Font object to change the font.

Exellent explenation. so beutiful. I am creating an interactive e learing quiz. Thanking you.

Hello! I have a client who’s interested in using tagging to help create searchable content within slides. For example, they have four different categories for slide content across multiple presentations (Overview, Market, Product, Country). I’d like to assign a different shape to represent each of the four categories, where a blue square might represent Overview slide content. Then, when someone uses the keyword “Overview” to search for overview content (on Teams or SharePoint), these slides are easily identified. Is this something that’s possible with VBA code?

Hi Linda. That’s a very good question! Given the need is to search via SharePoint, VBA probably won’t help here as the PowerPoint file needs to be opened for VBA to examine its content. I have a sneaking suspicion that if you add keywords in the Tags field under File / Info that SharePoint may use this. But, that’s at the file level rather than the slide level. We have a PowerPoint add-in called ShowMaker that might be of interest as it allows you to add category metadata to slides and then the presenter can use that to filter the deck and export the required content. You can find an overview of it here: https://www.brightcarbon.com/showmaker/ and we could set up a demo if you’re interested (please use the Contact button at the top of this page if that’s the case).

I’ve just created an elearning package in PowerPoint using VBA , I didn’t realise it could sum up text boxes within PowerPoint to mark the qualification at the end. Also used AWS text to speech over the top of the learning . Looks great

Sounds like a fun and successful project Stu! Thanks for sharing 🙂

I have a bit of a tricky one but hoping it is possible to do with VBA. We offer training services to multiple clients that can be customized but the majority of training is consistent from one client to the next (main changes are the slide masters/formatting and addition/removal of certain sections).

What we want to do is create one master (or multiple) training document(s), and then use VBA’s to link it to the client specific PowerPoint. We want to link the master rather than using the “reuse slide” command so that if we update one file the other will automatically update as well.

Not sure if it matters, but our company uses sharepoint as storage

Hi Dave and thanks for a great question. VBA is an excellent solution for automating a manual process. In general, if a person can perform a task manually via a sequence of pre-defined steps then VBA can do it automatically, faster, and with less chance of mistakes for something done many times. We’d be happy set up a call to discuss your needs further and see what could be automated with VBA. If that’s of interest, please use the contact button at the top of the page and mention my name in the form.

PP does not seem to have the record macro feature. To write vba code in PP by someone who only worked with vba in excel, would require some prior knowledge. Is there a summary of the most common objects, methods etc to refer to?

Hi Reef. You’re correct that there’s no VBA macro recording feature in newer versions of PowerPoint. The best place to start learning is by purchasing a book (there’s one called “Mastering VBA for Microsoft Office 365” on Amazon or reading the extremely exciting Object Model documentation from Microsoft: https://docs.microsoft.com/en-us/office/vba/api/overview/powerpoint/object-model

Hi Greeting I had made a game in power point using VBA codes. At last it generate a report every time a candidate conduct the game . My requirement is to generate result in same excel sheet after conducting the game. Like Row 1 player 1 result Row 2 player 2 result I need your help Regards

Hi Asheesh. It’s possible to use VBA to get PowerPoint to “talk” to Excel (and other Office apps) but it’s a bit complicated to mention in a comment here. We’d be happy to help if you’d like a quote or if you want to try yourself you could start with this: Set oXL = CreateObject(“Excel.Application”) and have a look at some online examples. I’d also recommend the book “Mastering VBA for Microsoft Office 365” available from Amazon.

If there are two colors of font in the textFrame, how to change the font of one color through VBA?

Hi Bruce. You could either iterate through the Characters collection of the TextRange2 object or the Runs collection which returns all of the TextRanges with the same style. Example: ActiveWindow.Selection.ShapeRange(1).TextFrame2.TextRange.Runs(1).Font.Fill.ForeColor.RGB

Hi – can you help, please?

How can I change the font color and size of the message box? What code will work and where will I put it? Creating an interactive game in powerpoint. Thank you!

—– Sub Correct() Points.Caption = (Points.Caption) + 10 Output = MsgBox(“Your answer is correct, well done!”, vbOKOnly, “Correct Answer”) ActivePresentation.SlideShowWindow.View.Next End Sub

Sub Incorrect() Points.Caption = (Points.Caption) – 5 Output = MsgBox(“Your answer is incorrect.”, vbOKOnly, “Wrong Answer”) ActivePresentation.SlideShowWindow.View.Next End Sub

Sub Reset() SlideLayout.Points.Caption = 0 ActivePresentation.SlideShowWindow.View.Exit End Sub ———-

Thanks for your explanation.

Hi Jamie, Is there any way to keep my macro save in a file so I can utilize on any other PPTs equivalent as.normal.dotm for Word, .xlam(add-in) for Excel.

Hi Anurag. Thanks for the question and Happy New Year! The best way to do this would be to export your project as a ppam and activate it as an add-in via the PowerPoint add-ins UI. Save your ppam in %AppData%\Microsoft\AddIns and then in the Windows PowerPoint Developer tab, click PowerPoint Add-Ins and add your ppam from there. If you’re not code-signing your VBA project, you may need to adjust Trust Centre settings. You could optionally build an EXE/MSI installer package for Windows and PKG for macOS, although that is a more complex topic.

Join the BrightCarbon mailing list for monthly invites and resources

The video animation looks AWESOME! Thank you sooooo much. I am very happy and proud with the result; this video is really convincing. Really really well done. Elodie Maurer SES

vba powerpoint exit presentation mode

Stack Exchange Network

Stack Exchange network consists of 183 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Prompt for password when exiting presentation

Is it possible to prompt for a password when exiting a full screen presentation in Microsoft PowerPoint?

I need to be able to show a presentation constantly, whilst leaving my computer, but do not want anyone else to be able to jump onto the computer while I am away.

I've looked into setting the presentation as a screen saver, but my company has default screen savers so cannot use this option.

I also looked into software which can display a presentation when a computer is locked, again company restrictions.

Only other option I can think of is to leave my computer un locked and running the presentation, but require a password to exit the presentation, is this achievable via a macro ?

In excel I would use a simple macro to protect/unprotect. not sure if this would work in PP.

  • microsoft-powerpoint
  • screensaver

DavidPostill's user avatar

  • You don't want to use PowerPoint to prompt for a password. It's trivial to force it to close, bypassing the VBA, for explore like example by pressing ALT+F4. Your question is suffering a bit from the XY Problem . Try editing it to ask how to solve your problem, not how to implement your proposed solution. –  I say Reinstate Monica Feb 27, 2019 at 11:30
  • It'll probably be better to convert your PowerPoint to a video and then you could use/write an application that has the functionality you desire... –  Kinnectus Feb 27, 2019 at 11:31

3 Answers 3

Unfortunately this isn't possible as users could still exit the application via Alt + F4, or through Task Manager.

If the slideshow is being presented on an external display, then a possible solution is to physically protect the computer from being accessed by other people.

Rowan Richards's user avatar

Keynote has this feature, you could try finding an emulator to emulate Keynote as an app. Keynote can also open Powerpoint files so you don't need a converter whatsoever. If you ever forget your password, I found out a simple fix for that. You can find the video here

Anonymous's user avatar

There are methods for locking a computer when you are away. Some of them are:

Dynamic Lock on Windows 10 Lets you lock your PC when your phone goes out of Bluetooth range. For more info see Microsoft's article Lock your Windows 10 PC automatically when you step away from it .

Lock My PC This free tool lets you override the default Windows lock screen (where other admins could still log in) by disabling the mouse and disc drives. You can trigger this lock with your own hotkeys, make the lock screen transparent, and even shut down or log off the user once the lock screen is up for a set time.

Predator Locks the computer using a USB stick as the key.

harrymc's user avatar

You must log in to answer this question.

Not the answer you're looking for browse other questions tagged vba microsoft-powerpoint screensaver ..

  • The Overflow Blog
  • Diverting more backdoor disasters
  • Featured on Meta
  • New Focus Styles & Updated Styling for Button Groups
  • Upcoming initiatives on Stack Overflow and across the Stack Exchange network
  • Google Cloud will be Sponsoring Super User SE

Hot Network Questions

  • A tic-tac-toe game in C
  • Differences in PSD for windowed vs non-windowed spectra
  • Did the flight service standard drop after Covid?
  • How to create grep output in the order of the input file?
  • MTG is there a situation where running 4 copies of a card with each different art has advantage/disadvantage over having identical 4 copy of a card?
  • derivative of the max function
  • Output a 1-2-3-5-7... sequence
  • Tutorial for expl3 regular expressions, specific question for non-numeral deletion from string
  • Print all legal chess moves
  • What is the best way to improve the ease of using metaphors?
  • How would one go about excavating a god's arrow buried into desert sand 40 ft deep?
  • Looking for a movie or made for tv film or miniseries that I saw in the 80s. Featuring VR and the decline of humanity
  • After creating HTML, why did Tim Berners-Lee bother creating HTTP? Why didn't he just write a HTML renderer for a FTP client?
  • How to perform amplitude amplification when the initial amplitude of aiming state is unknown
  • Old sci-fi episode/movie: man on a spaceship replaced his dead wife and kids with robot replicas
  • Recycle buying soda problem
  • What does one call the left and right sides of a building, in order to fix a point of view?
  • How can I draw a barrel like this?
  • Does scouring a stainless-steel pan cause it to release metals into food?
  • Ryanair seating policy: will two passengers be seated apart if you don't pay for a seat?
  • Why does microwave take more time to heat more food?
  • D&D 5e: Does the same spell prepared for different levels count as multiple prepared spells or the same prepared single spell?
  • How to make a device to randomly choose one of three possibilities, with caveat that sometimes one of them is not available?
  • Formula to count rows between positive values

vba powerpoint exit presentation mode

  • Mark Forums Read
  • View Site Leaders
  • Knowledgebase
  • Consulting Services
  • PayPal Donation
  • Advanced Search
  • VBA Code & Other Help
  • PowerPoint Help

VBA Code to Exit Active Powerpoint Presentation And Launch Another Powerpoint File

  • 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: VBA Code to Exit Active Powerpoint Presentation And Launch Another Powerpoint File

Thread tools.

  • Show Printable Version
  • View Profile
  • View Forum Posts
Hi there. I've created an extensive organization chart that spans many slides and files. I have broken things up and used hyperlinks to allow the user to navigate seamlessly between files as if they were all one presentation. It only recently dawned on me that as the user clicks on various hyperlinks, effectively opening multiple files, that all the files are open and remain in memory. This creates two problems: 1) a memory issue, given the multitude of Powerpoint files that could be open; and 2) a problem with exiting the slideshows as the user has to repeatedly hit the Esc key for each file that is open. That would be burdensome if 25+ files are open. Thus I thought to supplement the hyperlinks between files with a VBA macro that will close the active presentation in addition to navigating to the desired file. Theses macros would be triggered when the user clicks on an autoshape. Let's say File1.ppt is open and in slideshow mode. The user sees an Org Chart with three subordinates, each containing a hyperlink to another Powerpoint file. Let's say Org Chart subordinate 1 is linked to File2.ppt. I want a way to get File1.ppt to close and File2.ppt to launch in slideshow mode when the user clicks on the subordinate 1 object. Any thoughts would be greatly appreciated. Thanks!
Why don't you want to keep everything in a single PPT file? (other than size)? If there's macros in the linked slide shows, you'd get a macro warning each time. My 2 cents is that you'd have better control with everything in a single PPT with Action Buttons or Shapes with a hyperlink action to take the user where they wanted to go or exist. ALso no macro warnings to worry about.
One file would be huge. As it stands, I have about 190 files, most about 70 slides in size. I had to break them up becaus one file was just too large. Again, a memory issue. Furthermore, Powerpoint 2003 has a modest limitation as to the number of hyperlinks that any one file may contain and I was well in excess of the limit. The hyperlink limitation is what guided my decisions as to how to split things up.
That's a whole lot'a slides - the little test I tried with macros in each "sub-presentation" got the macro warning each time, and I didn't like that.
The vba would be simple code however as Paul says unless you have security set to low you will get warning messages. How about having a switchboard slide(s) with the main "menu" and then having "end show" buttons on all other shows to return to it?
John Wilson Microsoft PowerPoint MVP Amazing Free PowerPoint Tutorials http://www.pptalchemy.co.uk/powerpoi...tutorials.html
  • Private Messages
  • Subscriptions
  • Who's Online
  • Search Forums
  • Forums Home
  • Announcements
  • Introductions
  • How to Get Help
  • Non English Help
  • Access Help
  • SUMPRODUCT And Other Array Functions
  • Outlook Help
  • Office 2007 Ribbon UI
  • Integration/Automation of Office Applications Help
  • Other Applications Help
  • Project Assistance
  • Testing Area
  • Mac VBA Help
  • Other Mac Issues
  • Book Reviews

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  • BB code is On
  • Smilies are On
  • [IMG] code is On
  • [VIDEO] code is On
  • HTML code is Off

Forum Rules

  • VBA Express
  • Privacy Statement

MrExcel Message Board

  • Search forums
  • Board Rules

Follow along with the video below to see how to install our site as a web app on your home screen.

Note: This feature may not be available in some browsers.

  • If you would like to post, please check out the MrExcel Message Board FAQ and register here . If you forgot your password, you can reset your password .
  • Question Forums
  • General Discussion & Other Applications

Excel VBA Open PowerPoint into slideshow mode

  • Thread starter gmooney
  • Start date Feb 20, 2019
  • Tags mode open ppt set slideshow

gmooney

Active Member

  • Feb 20, 2019

Taking this code I would like to add the ability to have the PPT automatically open in slideshow mode: Private Sub MonthlyToplinePPT() ' Opens Presentation.pptx Dim PPT As Object Set PPT = CreateObject("PowerPoint.Application") PPT.Visible = True PPT.Presentations.Open Filename:="C:\Topline\Topline Writeup.pptx" Set PPT = Nothing End Sub Any thoughts?  

Excel Facts

Well-known member.

This looks to be working: Code: Private Sub MonthlyToplinePPT() ' Opens Presentation.pptx Dim PPT As Object Set PPT = CreateObject("PowerPoint.Application") PPT.Visible = True PPT.Presentations.Open Filename:="[COLOR=#333333]C:\Topline\Topline Writeup.pptx[/COLOR]" With PPT.ActivePresentation.SlideShowSettings .ShowType = ppShowSpeaker .Run.View.AcceleratorsEnabled = False End With Set PPT = Nothing End Sub  

  • Feb 21, 2019

Thanks mrshl9898....worked perfectly!  

Similar threads

  • picklefactory
  • Jun 7, 2023
  • Dec 6, 2023
  • Green_Square_Window
  • Feb 6, 2024
  • Mar 30, 2023

NdNoviceHlp

  • Feb 27, 2023

Forum statistics

Share this page.

vba powerpoint exit presentation mode

We've detected that you are using an adblocker.

Which adblocker are you using.

AdBlock

Disable AdBlock

vba powerpoint exit presentation mode

Disable AdBlock Plus

vba powerpoint exit presentation mode

Disable uBlock Origin

vba powerpoint exit presentation mode

Disable uBlock

vba powerpoint exit presentation mode

vba powerpoint exit presentation mode

Contribute to the Microsoft 365 and Office forum! Click  here  to learn more  💡

April 9, 2024

Contribute to the Microsoft 365 and Office forum!

Click  here  to learn more  💡

  • Search the community and support articles
  • Microsoft 365 and Office
  • Search Community member

Ask a new question

How to fix PowerPoint crashes when running VBA macros?

Dear Microsoft Support Team,

I am writing to request your assistance with an issue I have been experiencing with Microsoft PowerPoint. Whenever I try to run a VBA macro in PowerPoint, the application crashes or closes automatically, preventing me from completing my work.

I have tried a number of troubleshooting steps, including restarting my computer, checking for updates, and scanning for viruses, but none of these measures have resolved the issue. I am concerned that there may be an issue with my PowerPoint installation or with the compatibility between my PowerPoint version and the VBA code.

As I rely heavily on Microsoft PowerPoint and VBA macros for my work, I am hoping that you can provide me with some guidance or assistance in resolving this issue. If possible, I would appreciate it if a member of your technical support team could work with me to identify the root cause of the problem and help me find a solution.

Thank you for your time and consideration. I look forward to hearing back from you soon.

Hariprasath

Report abuse

Replies (3) .

Jazlyn Xu MSFT

  • Microsoft Agent |

Dear Hariprasath,

Good day! Thank you for posting your query in our community.

Based on your description, when running VBA macros, PowerPoint crashes. To narrow down the scope of the issue, please provide more information for us:

Does the problem happen on all the VBA macros, or specific macro on a file?

If you run the VBA on another device, will the same problem happen?

Please provide a screenshot of your Office Product Information(open PowerPoint>File>Account>capture a screenshot of the Product Information column).

Appreciate your cooperation in advance.

Jazlyn | Microsoft Community Moderator

1 person found this reply helpful

Was this reply helpful? Yes No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

Thanks for your feedback.

Steve Rindsberg

  • Volunteer Moderator

>> If possible, I would appreciate it if a member of your technical support team could work with me to identify the root cause of the problem and help me find a solution.

Not really possible, I'm afraid. The MS support people here are pretty good but generally aren't familiar with VBA. There are some volunteers who are, though.

Do you get a crash with ANY code or just some specific code?

The first step to getting help would be to reduce your code to the minimal example required to provoke the crash and post it here.

John Korchok

An Office repair can fix these symptoms: Repair an Office application

Question Info

  • For education
  • Norsk Bokmål
  • Ελληνικά
  • Русский
  • עברית
  • العربية
  • ไทย
  • 한국어
  • 中文(简体)
  • 中文(繁體)
  • 日本語

IMAGES

  1. How to use VBA in PowerPoint: A beginner's guide

    vba powerpoint exit presentation mode

  2. How to use VBA in PowerPoint: A beginner's guide

    vba powerpoint exit presentation mode

  3. what are presentation mode

    vba powerpoint exit presentation mode

  4. How to use VBA in PowerPoint: A beginner's guide

    vba powerpoint exit presentation mode

  5. How to use VBA in PowerPoint: A beginner's guide

    vba powerpoint exit presentation mode

  6. VBA PowerPoint

    vba powerpoint exit presentation mode

VIDEO

  1. 【VBA】 25 跳出循环 Exit For和Exit Do

  2. How To Create PowerPoint Presentation Using ChatGPT WITHOUT Running VBA Code

  3. VBA Final presentation

  4. Présentation VBA

  5. Compare 3 Excel Drop Down List Types for Data Entry

  6. Microsoft PowerPoint: How to Change the Exit Animation Direction

COMMENTS

  1. SlideShowView.Exit method (PowerPoint)

    Exit. expression A variable that represents a SlideShowView object. Example. This example ends the slide show that's running in slide show window one. SlideShowWindows(1).View.Exit See also. SlideShowView Object. Support and feedback. Have questions or feedback about Office VBA or this documentation?

  2. vba

    1. Using Insert>Action>Run macro, assign this to a shape, then copy the shape to each slide. The shape can be the same color as the background if you want it to be unobstrusive: Sub ExitSlide() ActivePresentation.SlideShowWindow.View.Exit. End Sub. answered Aug 20, 2020 at 18:22. John Korchok. 4,853 2 12 22.

  3. Using VBA to switch to presenter view when starting a slide show

    Close all Office programs. Search for Control Panel, then open it. Choose Programs, then Programs and Features. Select Microsoft Office 2013, then choose Change. Select Online Repair, then click on the Repair button. Allow the process to complete, restart your computer, then check Slide show> Use Presenter View and see if presenter view comes ...

  4. PowerPoint VBA

    1. I know I could do the following to run code when the slide is changed in presentation mode -. Sub OnSlideShowPageChange() Dim i As Integer. i = ActivePresentation.SlideShowWindow.View.CurrentShowPosition. If i <> 1 Then Exit Sub. 'Code that should happen when slide changes goes here.

  5. How to come out of Presentation Mode without closing a powerpoint

    Right-click & select End Show from the contextual menu. Press Command+. (Command+period) Press the Hyphen (-) key. When in Presenter View, all but the Hyphen method should return to Normal View, as well. In Presenter view, however, there is an End Show button ⊗ in the upper left corner of the window. If neither of those methods is working for ...

  6. PowerPoint VBA Macro Examples & Tutorial

    Create PowerPoint Macro. This is a simple example of a PowerPoint VBA Macro: Sub SavePresentationAsPDF() Dim pptName As String Dim PDFName As String ' Save PowerPoint as PDF. pptName = ActivePresentation.FullName. ' Replace PowerPoint file extension in the name to PDF.

  7. How to use VBA in PowerPoint: A beginner's guide

    Getting to meet your VBA friend is very simple. With PowerPoint open and at least one presentation file open, press Alt+F11* on your keyboard. This will open the VBE (Visual Basic Editor): *If for some reason Alt+F11 isn't mapped on your keyboard you can right click anywhere on the ribbon, select Customize the Ribbon… and in the window that ...

  8. vba

    Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site

  9. VBA Code to Exit Active Powerpoint Presentation And Launch Another

    Let's say File1.ppt is open and in slideshow mode. The user sees an Org Chart with three subordinates, each containing a hyperlink to another Powerpoint file. Let's say Org Chart subordinate 1 is linked to File2.ppt. I want a way to get File1.ppt to close and File2.ppt to launch in slideshow mode when the user clicks on the subordinate 1 object.

  10. Excel VBA Open PowerPoint into slideshow mode

    Taking this code I would like to add the ability to have the PPT automatically open in slideshow mode: Private Sub MonthlyToplinePPT () ' Opens Presentation.pptx. Dim PPT As Object. Set PPT = CreateObject ("PowerPoint.Application") PPT.Visible = True. PPT.Presentations.Open Filename:="C:\Topline\Topline Writeup.pptx". Set PPT = Nothing.

  11. Powerpoint slideshow escape vba

    is do have a powerpoint presentation that will be opened in slideshow mode directly from Excel. i've managed from powerpoint VBA to close the slideshow without asking to save the file. unfortunatelly if the user press "ESC" key duing the presentation the slideshow get closed and the pop-uop asking to save the file is showed. i don't want to ...

  12. How to fix PowerPoint crashes when running VBA macros?

    Based on your description, when running VBA macros, PowerPoint crashes. To narrow down the scope of the issue, please provide more information for us: Does the problem happen on all the VBA macros, or specific macro on a file? If you run the VBA on another device, will the same problem happen?

  13. How can I run VBA code when a PowerPoint slide opens

    Full code:. Public Sub OnSlideShowPageChange(ByVal Wn As SlideShowWindow) Dim i As Integer Dim sld As Slide Dim shp As Shape Dim boxText As String Set sld = ActivePresentation.SlideShowWindow.View.Slide MsgBox "slideshow index is " & sld.SlideIndex If sld.SlideIndex = 5 Then For Each shp In sld.Shapes If shp.HasTextFrame Then boxText = shp.TextFrame.TextRange.Text If InStr(boxText, "10 seconds ...