Ms. Compy Fix-It: Tackling PowerPoint’s Manhattan Skyline

Hi folks!

Ms. Compy Fix-It here!  Come to your (potential) rescue once again.

Today’s topic is one I’m happy to say has been resolved: Manhattan skylines in PowerPoint Print Previews.

Never heard of them?  Well, some people have called them that because they are vertical bars that are not in your document, but suddenly appear when you print or hit Print Preview.  Depending how many you have, you can end up with quite a dramatic print job.

I encountered them when trying to print a coworker’s slide, and honestly was surprised they showed up in the Print Preview – I thought this might be one of those weird printer configuration/”it’s not us, it’s your printer” Microsoft kind of issues, but I was wrong.

I did some digging, and was surprised to not find very much that was helpful.  I looked closely at the bars and could see they all seemed to stem downward from a title.  Have a look below.  I deleted all but the titles, as the rest is irrelevant.

Image

I thought maybe it had to do with text box fill, but that came up empty.  The clue that pushed me to the Ms. Compy Fix-It idea came from this link: http://www.mombu.com/computer_design/acrobat/t-unwanted-vertical-lines-on-screen-and-on-print-3586463.html from sharon_bloor.  She suggested it was a text issue, and although the font didn’t appear strange or particularly new, I thought it was worth a try to just Ctrl+A (highlight all) and change the font to Calibri.  Sure enough, when I hit Print Preview, the bars were gone.

Image

Hope this helps someone else!!

Yours in PowerPoint suffering fixing,

Ms. Compy Fix-It  🙂

Advertisements

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
    Next
Next

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?  🙂

 Enjoy!

Ms. Compy Fix-It Needs a Better Compy

Ms. Compy Fix-It here, with another post of computer awareness.

The last few weeks have been stressful indeed, with multiple problems on my work computer creating suspicions that ranged from simple Anti-Virus issues to core hardware malfunctions. I don’t even want to admit the number of hours both my boyfriend and I have logged trying to fix this jerk (no offense compy, I mean no harm). Here is a list of some of the things we did to give you an idea:

  • uninstall Windows Defender.  Didn’t seem to help, so just deleted it.
  • uninstall McAfee entirely.  No subscription, so would only be good for scans, and I had other programs to do that.
  • made sure SpyBot and MalwareBytes didn’t have any resident applications running.  I had Avast, so decided to commit and keep those guys as scanners.  Besides, for some reason, SpyBot’s TeaTimer always used approximately 84,000K of Memory on this computer and I always had to Task Manager End Task it to oblivion.
  • checked all video drivers to make sure they were up-to-date.
  • uninstalled the video drivers and re-installed them just to make sure.
  • uninstalled Avast because at one point it said it wasn’t running, but when I clicked “start program” it didn’t do anything.  Re-installed Avast because frankly it’s worth it.
  • tried to use Internet Explorer in case it was a Firefox issue.  Seemed to have the same problems.
  • re-formatted.  Twice.
  • allocated nearly an entire 10 Gig partition to paging file.

So, the issues were as follows:

  • every few seconds, whenever I’m typing, the web browser (both Firefox and Internet Explorer) pauses, like it’s doing right now, and a few seconds later it catches up to what I’ve been typing.
  • sometimes when it does this, the whole browser goes non-responsive and a few seconds later usually comes back.
  • in other programs, like PowerPoint, certain things would cause the program to do the same thing.  For example, I remember specifically trying to change the colour of one bar in a chart and this happened.  That’s what made us wonder if it was a video driver issue.
  • scrolling would often pause the web browser and cause it to go non-responsive.

These may not seem like big issues, but a couple of times the non-responsive didn’t go away and had it not been for auto-recovery and auto-saving, I would have lost a whole heckuva lot of data.  Also, I can’t look when I’m typing or I’ll confuse myself as to what’s been typed (since it crashes and I can’t see what I’m actually typing in real-time).  That wouldn’t matter so much if I were writing posts all the time, or essays, or just typing a lot.  The problem is I’m often doing minor edits in presentations and I’m not sure if the program’s noticed my change or not, and it totally slows down my ability to work.  Also, it’s frustrating as heck.

Anyway, I started typing this because I found a site that claimed to have a solution that I wanted to test out and give kudos to, if it worked.  It did not.  No kudos to give today.  😦  Ms. Compy Fix-It needs your help.