Help! My keyboard, mouse, and/or pointer does not work while in PowerPoint Slideshow view!

In August, I was the instructional designer charged with hosting an 8-hour training event. It went very well, but just when I started the first PowerPoint presentation in slideshow mode, I realized my laser pointer didn’t work (and new batteries didn’t help!). Then I realized my keyboard and mouse were also not responding.

To get around this issue on the day of the training, I started the slideshow using the “Rehearse Timings” button.

Rehearse Timings

Rehearse Timings

This meant having the Rehearsal window open during my welcome presentation. More importantly, I could continue the day without interrupting other modules. Fortunately, only the Welcome presentation was affected, and my SMEs (subject matter experts) were safe.

What Happened?

After some digging, the reason why I could not use my keyboard or mouse while in Slideshow View was due to the Kiosk setting. When a presentation is in kiosk mode, certain keyboard and mouse events are unavailable, and some PowerPoint controls do not work during the slideshow.

How Do I Fix It?

When stuck in kiosk mode, simply use the Escape key to exit the slideshow and return to normal view in PowerPoint. Follow these steps to shut off kiosk mode:

  1. Click the Set Up Slide Show button from the Slide Show ribbon.

    set up show window

    Set Up Slide Show window

  2. In the Show type group, change the setting to “Presented by a speaker (full screen)”. This is considered the best setting for projecting a presentation.
  3. Click OK.
  4. Save your PowerPoint file. (options in Set Up Show are stored in your PowerPoint!)

While you have Set Up Show open, be sure to poke around some of the other available settings… though most of these settings are now available from the ribbon in 2007 and up. Although my problem was very specifically kiosk mode, the Advance slide group settings could also have created a fairly similar issue.

How Did This Happen?

Three words: I did it.

This setting was turned on when I decided to reuse some of my welcome slides for mini-slideshows I use in between modules. I turned on the kiosk mode by accident on both slide decks instead of on the new one. When I realized that it was a problem only in one presentation, I was able to trace back the steps I made to figure out the problem.

It can happen to the best of us. In an effort to reuse and re-purpose things, accidents can and do happen. If I had given someone else this deck with kiosk mode enabled, I could have caused a lot of grief!

Advertisements

Getting Started with Macros: How to Turn on and Use the Developer Ribbon in PowerPoint (or any MS Office tool)

macro iconMacros can be very useful but often go unused. Having always been somewhat of a hack, I do not like to take no for an answer. Macros have helped me work around problems which seemed unsolvable.

Although this post does not contain a single macro file, I plan to write a few posts about specific macros to make an instructional designer’s job a little easier. I will be focusing on PowerPoint as the venue for these macro blog posts, but you can use this info to use Macros in most of MS Office.

In this post, I will cover a few macro basics:

What is a Macro?

According to dictionary.com, a macro – short for macroinstruction – is an instruction that represents a sequence of instructions in abbreviated form (http://dictionary.reference.com/browse/macro). An example of a real-world macro would be going to work. If my abbreviated form, macro statement is going to work, then my sequence of instructions would really be:

  • Gather work items
  • Open car door
  • Close car door
  • Put on seat belt
  • Place key in ignition and turn
  • Place car in reverse
  • etc, etc, etc, until I arrive at work

Someone will ask me to perform the going to work command instead of telling me each and every step of going to work. At the end of completing the instruction going to work, my physical appearance at work is proof that the macro ran successfully. If I did not make it to work, then going to work failed, and “troubleshooting” ensues 🙂

Macros are pretty much the same thing. A macro can type for you, add objects, set formatting, open files –  essentially anything you can do on a computer, a macro can redo for you. They can be simple commands (1. copy; 2. paste; 3. move down one line), or they can be complicated – capable of making decisions based on data you provide.

(back to top)

The Macro File Type

notepad macro example

This is a macro in Notepad.

A file with the .bas extension can be opened in PowerPoint and run as a macro. Macros are written in any text editor – I usually use Notepad. When done with my text file, I change the extension from .txt to .bas.

Not a programmer? No worries! Part of the beauty of macros is the ability to share them. You will likely find little snippets of code online, and you will be copy/pasting them into Notepad or some other text editor (or directly in the Visual Basic editor). However, please be cautious about where you get macros! They can be used for good as well as for evil. The same way you would not eat food found on the street, you should use caution when finding macros online.

(back to top)

How Do I Use Macros in PowerPoint?

Macros can be run from the Developer ribbon in PowerPoint (or Word or Excel). If you already have a macro, here are the steps to run it (see a short video clip here).

developer ribbon

Developer Ribbon in PowerPoint

  1. Click the Developer Ribbon in PowerPoint
  2. In the Code section, click the Visual Basic button
  3. In the window that opens, click
    macro window

    Macro window

    File > Import File…

  4. Find and open your macro file
  5. Close the Microsoft Visual Basic Window (use the X in the top-right corner)… you will be returned to PowerPoint
  6. From the Developer Ribbon, click Macros
  7. With your macro selected, click Run

When you try to save your presentation after using a macro, you may be prompted to save it as a .pptm file. However, this can be considered undesirable. Do you need to do this? The short answer is no. You can simply Save As a .pptx.

In my opinion, there are two good reasons to save as a .pptm, and both must be true:

  1. Can you share .pptm files? Some IT Departments will restrict these file types, because they can be used by bad people to do damage to your computer. If you can’t save a .pptm file, you can likely still save your finished work as a .pptx file.
  2. Are you and your team okay with using a .pptm? File types can be confusing, and some people may be wary to open the file, and some software (like web conferencing applications) will not recognize a .pptm as a PowerPoint file. Do your research first!

Help – Where Is My Developer Ribbon!

If you found that you got stuck above at Step 1: Select the Developer Ribbon because the ribbon isn’t there, don’t fret (yet…)!  Unless you are on IT lockdown, you can enable your Developer ribbon using the steps below (you can also view a short video here):

  1. Click the Office Button

    enable developer ribbon

    Where to turn on your developer ribbon.

  2. Select PowerPoint Options (lower right corner)
  3. Make sure there is a check in the box next to “Show Developer tab in the Ribbon”
  4. Click OK

Note that this setting may be hidden, grayed out, or made unavailable due to your IT Department’s security policies. If this is the case, please reach out to your IT Department for further assistance.

(back to top)

[CYA] Disclaimer 🙂

Perception of macros are pretty broad, and sometimes the unknowing person can make them sound like they pose a devastating threat, akin to leaving your keys in your car, with all the windows open and a sign that says “STEAL ME!”.

Generally, people can do bad things with macros, but if you are not looking to do bad things, nothing I ever tell you or show you will ever get you into trouble, break PowerPoint, or make you lose data. However, macro security is important. Do not use macros from untrusted places or sources. I will show you how to build macros, and if they do not work, they simply stop running. If you stray from my steps, risk-wise, you are on your own… but I encourage calculated curiosity and do wish you lots of luck!

(back to top)

First Time Hosting an All-day Instructor-led Course

Yesterday was the first time I was host for an all-day training. Although my past experience may have helped me prepare for all this stuff, there were some things which surprised me. I’ve been the instructor for five-day software training events, some where it was business analysis followed by training. I was the instructor for a 14-week A+ certification course. I’ve taught 8-week Microsoft Office adult ed classes. I’ve hosted countless numbers of WebEx training sessions, and I have somewhere around 30 eLearning courses under my belt.

Being the host of an all-day event required pulling from my personal experiences, but it also made me realize that there was far more expertise involved. Here’s a diary of the day.

The course was scheduled to start at 8:30am. I was at work until almost 7pm the day before setting up the room and adding last minute printouts to the student handbooks (individual presentations are also posted online).

  • 07:30am: Planned time of arrival to work
  • 07:42am: Actual time of arrival to work (thanks, Springfield traffic)
  • 07:46am: BSOD (blue screen of death) when I tried to print the script for the class
  • 07:52am: Finally got the room. A SME was already there before me. In my head, I was chagrined.
  • 08:02am: Confirmed with IT that everything was up and running.
  • 08:15am: Realized the laser pointer was not functioning. Went on a pilgrimage to find AAA batteries.
  • 08:20am: The two brand new sets of batteries did not fix the laser pointer. I announced to the class to eat food… I will be back. I went on a second, high-speed pilgrimage to find a new clicker.
  • 08:29am: My second pilgrimage failed, so I ran back to get to the front of the room, thinking, it’s okay, we’ll make due without the clicker.
  • 08:30am: I turned on the slide show for my presentation, and the keyboard and mouse stopped responding. I buried my head behind the laptop (though everyone could see the projector) and my brain went into IT Troubleshooting mode.
  • 08:30am: I determined that some setting in reused slides was the problem. I turned on Rehearse Timings during my presentation… it was the only way I could get the keyboard and mouse to work.
  • 08:32am: My worst fear – I started two minutes late! I rolled through my module almost apologetically, forgetting the best practice to not point out flaws. The timer window in top-left corner of the presentation was a constant visual that something went wrong.
  • 08:40am: My first SME took the stage – right on time! Did anyone else notice that I ran through the room introductions like a drill sergeant? STATE YOUR NAME. STATE YOUR TITLE AND DEPARTMENT. STATE THE YEAR YOU STARTED. NEXT. NEXT… MOVING ON. Ouch.
  • 09:20am: I set the timer on my iPhone but forgot to shut it off when the module was done, so after directing that all mobile devices be set to silent, mine started beeping. Chagrin, again.
  • 09:21am: I realized I needed a bin to place the evaluations, so attendees started placing them in different spots. I corralled the evaluations and apologized for not providing a bin.
  • 09:30am: As soon as the next presentation began, I ran off and stole the first plastic “thing that would be the evaluation bin” from next to a random printer.
  • 09:32am: I realized that the bin that I stole had about three years of dust on it. Made a pit stop to clean it.
  • 10:35am: Thinking the SME was lagging behind, I held up a sign that said, “SPEED UP”, and then my SME finished 5 minutes early. Chagrin, again. I decided to limit my use of this agreed-upon cue for every other SME.
  • 02:10pm: Forgetting to reset my timer app, I based all of my cue cards off of an 1:10 class when it should have been an hour. Thinking he finished early, this SME was the first to finish late… and it was because of ME!!!! (Chagrin x 100)
  • 04:08pm: I took the stage 12 minutes early to present a small piece on our company’s website redesign. This was the first instructor-led course I presented since August, 2009. As I began to show the main navigation of the site, I looked out to see some of my attendees looked like they were going to fall asleep, die, or kill me. I cut 2/3 of the demo portion of my presentation out, completely sure I was going to get a score of 1 out of 5 and a resounding, “What the heck was that crap???” from the group.
  • 04:30pm: The class was done! And, on a beautiful summer day, I let everyone out 1/2 hour early.

So, this sounds like it should have been a disaster? It certainly did to me. However, for as devastating as all these things were, I had a few people tell me it was one of the best training programs they’ve attended. My evaluation was over a 4.5 out of 5.

In retrospect, I think I may have been the only one to notice most of this.

  1. I need to be more confident. My husband will probably read this and say, “I TOLD YOU SO… AGAIN!” A knowledgeable and well-respected colleague noted that I have the skills needed, but I need to have confidence that I’m competent. I continue to work on and struggle with this..
  2. Instead of sweating the small stuff and beating myself up, I should instead appreciate my problem-solving capabilities. Nothing that went wrong was the end of the world. It felt like it to me. Simple mistakes made me feel stupid, incompetent, and inexperienced. I’m actually kind of good at what I do (and that was the hardest thing to write on this page).
  3. SMEs do not all think or present the same, and the more I can accommodate their needs, the better they will present. Some have 20 years of instructing experience while others have just begun. What became very important during planning was to understand how each SME presents and to support each style.
  4. Tone down personal enthusiasm and limit my goals realistically. As my first instructor-led experience in my current capacity, I wanted to employ every technique that would make the day better. More examples! More scenarios! A full-fledged student workbook instead of PowerPoint slides! I handled a lot of my meetings as if they were brainstorming sessions. I think I created some extra stress for my SMEs. I treated some preparations as if I needed SMEs to chime in and approve every detail, while patting me on the back and telling me it’s all wonderful (back to point #1: I need to build confidence).
  5. Some decisions should be left to the me, the instructional designer, and that’s OK. This goes hand-in-hand with point #4 (and #1, again). It’s important for me to focus my SMEs on what they can do to improve the content that requires their expertise. It’s also important to realize that they have a bit part in an entire day, and that should be okay with me. Post-training feedback was that they didn’t care about a lot of the little things that make an entire day great, but they liked them. For example, I added a photo slideshow in between each session to run during break. I brought it up several times in planning sessions but got nearly nil feedback from SMEs – I almost nixed it because of the lack of interest. However, the slides sparked interest in the room, and I found SMEs and students congregating in front of a picture of a generator, sharing interesting stories about the industry! I loved it. I wanted to take pictures of the scene. What can I do for my SMEs without their blessing, and will the addition make things easier and better?
  6. Project management experience trumps instructor experience in some cases.  This is pretty self-explanatory; however, I would like to point out that to prepare for this, I found myself expanding my internet searches. Initially, I was looking at all best practices for the classroom and for business presentations. Ultimately, I found a lot of time management, leadership training, and business partnerships training to be very valuable to me.
  7. Last but not least – Sheesh! I need to see more of the positive stuff! I intended to only write my happy take-aways from this course, but the timeline is what came out.

Reviewing my timeline, I can summarize my next steps with a promise: On October 1st, I deliver this same day-long course again. I am going to post the same kind of timeline, but I am going to highlight all the good things. And it’s going to be excellent. Sound convincing? 😉