Ms. Compy Fix-It: Delete Your Notes from PowerPoint

Hi all, Ms. Compy Fix-It here, with another life-saving (or at least semi-interesting) tip for PowerPoint.

Have you ever been revising an old file that had a lot of unwanted notes, and thought, “Gee whiz, I wish I could delete all of these notes with the click of a button!”  Well, you can’t.  But you can click about 3 buttons and should get to your result.  Beautiful?  I think so, too.

Here’s how, thanks to: Ohad’s blog.

Go to your presentation.  Make sure you save it.  Copy the following text to use later:

Dim objSlide As Slide
Dim objShape As Shape

For Each objSlide In ActivePresentation.Slides
    For Each objShape In objSlide.NotesPage.Shapes
        If objShape.TextFrame.HasText Then
            objShape.TextFrame.TextRange = “”
        End If

In your presentation, open View, then click on Macros.  In the Macro Name field, type RemoveNotes (or whatever name you want to use in order to use it again later for other presentations).

Click Create.  It’ll open up your VBA, which for all I know means Very Big Anomaly.  Anyway, don’t click anywhere else because it’ll bring your cursor right where it needs to be.  Here’s where you can paste that coding I had you copy earlier.

Now click X to close (don’t worry, it’s not going to close your whole presentation).  If you’re not back at your presentation, click X again (you just closed the VBA window!).

Now you should be back in your presentation, and don’t worry, you’re not supposed to notice anything different.  Now, you go to View again, Macros again, and you should see your Macro in the box list.  Select yours, click Run, and bingo, you’re done!  Okay, a few more than 3 buttons, but still, wasn’t that easy?  🙂


Ms. Compy Fix-It’s Disappeared Row…..

Ms. Compy Fix-It here, bringing you another episode of computer frustration resolution.  Today’s topic will be the random row that just won’t unhide.  You may have intentionally hid it, and now it’s causing you trouble because it’s just that shy.  Here’s what you can do:

  • If you’re like me and accidentally Froze Panes before freezing the actual panes you intended to, no combination of scrolling or resizing will work.  You’ll just need to go to Unfreeze Panes and you’re set.
  • In researching online I found a site that discribed a similar problem, but their cells actually wouldn’t resize….. check out here if that’s your problem.  Chances are you’ll need to hit F5 and go to the cell in the row that’s the problem (or just type it into the cell name field up top by your menus), Format Row Height (it’s under the Cells tab in 2007), and type 12.75.

That’s all folks.  Let me know if you have other instances where this happens, or if you have another problem altogether!  I’m all about the detective-iness.

Hope that helps!  🙂

PowerPoint Just Wants to Hurt Your Feelings

Hi all, Ms. Compy Fix-It here.

Today, I found a new suggested solution to my PowerPoint constantly crashing.  I had the problem where any editing of embedded charts/graphs using Excel would often cause it to freeze and require the computer to shut down PowerPoint and “try to recover data”.  Sometimes, it recovered all of it; other times, barely any.  I used to have this problem frequently with a computer that ended up having a hardware issue, so I used to blame that.  Then, I got a second-hand laptop to try, and boy, still a lot of crashes.  Finally, I get this, a barely-used HP beaut with big screen and presumably better system.  Well, guess what?

SO!  I figured I couldn’t be the only one, and did some more digging online….. my spec-i-al-i-ty!  (Wow, I just realized that was quoting one of my favourite childhood movies, The Neverending Story….. I heard the professor’s voice saying that, so I tried to spell it out accordingly.  haha I am a true geek.)

Sure enough, I found this site.  Again, thanks to Microsoft Answers, someone suggested getting this HotFix.  So far, so good.  I’ll report back if it’s junk, though  😉

One thing to note: if you do download this fix, make sure that your problem is exactly what is written in their description.  I don’t want you installing unnecessary patches for problems you may not have….. and also, be sure to follow their instructions (including backing up stuff).  I don’t want people to say I didn’t warn them in case it doesn’t work quite right.  I also did a System Restore point, though I don’t know what the difference is between that and a Backup, to be honest.  I just didn’t have any DVDs/time to run the backup, so I thought that was an okay alternative!  haha hey I never said I knew everything about computers….. heck, why do you think I’m Ms. Compy Fix-It?!

Anyways.  One other thing to note: for me, when I installed the fix, I got scared because when I went to my folder to retrieve a file I’d been working on, it was in PowerPoint Viewer!  I thought it did something to my program/deleted it or something, but all you need to do is right-click your file and go to “Open with…..” and it should give you a choice to select the Default Program, and your regular PowerPoint program should be there as an option.  Make sure to check the box, “Always use the selected program to open this kind of file” to ensure all the rest of your PowerPoint documents open as they normally did.

Happy PowerPointing!

Ms. Compy Fix-It: Adding Labels to Scatter (or any) Charts in Excel

Hi all, Ms. Compy Fix-It here, with another gem of a trick to help you.

So, I was working on some scatter plot charts in Excel, and needed to add labels.  As it is, when you click “Show Data Labels” in Excel, it gives you the two pieces of data in the form of coordinates.  Now, maybe that’s helpful for some people, but it is a lot more useful to me to actually describe each point in the form of a variable name.  I knew someone out there must have had the same thought, so I did a quick search which proved I was not alone.

Thanks to this site, I was referred to the program XY Chart Labeler, which did exactly what I was hoping: added labels to my data points.  You even have the option of where to place the labels, which I’m sure will be quite helpful too.

Hope this helps!

— Ms. Compy Fix-It

An Open (Passive-Aggressive) Letter to SPSS

Dear SPSS,

I just want to thank you.  Through your use, I have become more patient with humans, more sympathetic to other SPSS users, and more tolerant of my computer’s own delinquencies.

Thank you for being so essential in the workplace, yet being so difficult to use, decipher, and repair.  I am sure this makes me a more analytical and intelligent human being.

I appreciate your encouraging my independence by ensuring the only help I receive is via other posters on the internet desperately writing into the World Wide Abyss hoping by chance someone else a.) also had that problem, b.) was not still rocking back and forth in the fetal position, and c.) cared enough to post the solution.  Thank you for requiring a SPSS Survival Manual, SPSS for Dummies, and step-by-step books because you are too difficult to figure out by pure logic.

Thank you for preventing me from seeing the light of day.  Really, melanoma should not be taken lightly.

And finally, thank you SPSS creators, for ensuring that everyone who has not used your program will not possibly understand the difficulties and inexplicable behaviour which your program guarantees, thereby increasing our opportunities to develop ridiculously complicated work-arounds just to “find a way to get it done”.  This, I’m sure, has made me more in touch with my creative side.  I also have to wash less of my hair.

In all, thank you SPSS, for making me a better human being.  Now, with all due respect, please interpret my passive-aggressive letter as an upwardly-aimed central manual appendage displayed in your general direction.


Custom Tables in SPSS

Hi all, Ms. Compy Fix-It here to ask for some assistance.

When creating a Custom Table, I would like to select a variable for the column, Column N %, and a question for the rows.  Such a seemingly simple task works for other users, but when I run it, it stays at “Processing” eternally.  One difference I had compaired to someone whose SPSS was working properly, was that when I select Column N % in the Summary Statistics segment, he had the option “Apply to All” available, whereas mine is greyed out.


Any ideas?

Ms. Compy Fix-It: 1, HP Photosmart C4280 All-in-One.. machine thing: 0

Today’s episode comes at an opportune time with the holidays coming up and lots of pictures ready to be taken and uploaded. If you receive hard copies of pictures you’d like to scan, but are getting an error like “USB not connected”, read on.

So today I wanted to scan a page. Rare occurrence indeed! I press my Scan button. “USB not connected”. Really? I check; it is connected as I thought.

I investigate in my Control Panel Scanners and Cameras menu. No HP. I think maybe it’s a driver issue, so I move the USB to another port on my computer. It installs new hardware. I investigate in my Control Panel Scanners and Cameras menu again. Yay! — it’s there.

I press the Scan button again; “USB not connected”. Bastard.

This is where I use my wonderfully-toned research skills to scour the internet for other saps with the same problem…… seems like I’m not alone — not by a long shot.

Thanks to this support forum’s comments, I’ve found a way to scan in the meantime, just by opening Paint. Didn’t even occur to me to try it!   Click here if you want to read other people complain about this:

If you’re having the same issue as me, don’t worry if HP’s programming doesn’t let you scan….. just use a regular photo program to access the scanner.

Happy Holidays friends!