Sent Twitter Tweets from Excel 2007!

Recently I have been rummaging through the blogs over at MSDN and I just stumbled across what has to be one of the best Excel 2007 posts of the year!

Microsoft Excel and Twitter via Smart Tags in a VS 2008 Solution

Basically, John Durant (a Microsoftie) has built some code which enables him to use Smart Tags to tweet the contents of a cell with only a couple of clicks.

How cool is that!  If you are interested in extending the functionality of Excel 2007, make sure you read more in John’s post here.

And if you are on Twitter, why not follow @thenewpaperclip for regular Office 2007 hints, tips, tricks and tutorials.

(and if you are really bored, you could follow the guy who is behind The New Paperclip – @paulwoods)

‘till next time!
TNP :)

Add ruled lines to pages in OneNote 2007

If you are anything like me, your handwriting is very very bad!  In fact, if you are really like me you need all the help you can get to ensure that your handwriting is legible!

Well if you are using your pen or stylus in OneNote 2007 to take notes, there is an option to help you at least write straight lines!  They are called Rule Lines, and are really easy to add to pages in your OneNote 2007 Notebooks.  Here is how…

1) Open up your notebook, and go to the page you want to add Rule Lines to

2) Click on “Format” in the menu

3) Click on “Rule Lines”

4) Select your preferred rule line option


There are a number of different line rules you can use to ensure you can get the most out of your OneNote 2007 notebook.  They are:

  • Narrow Ruled
  • College Ruled
  • Standard Ruled
  • Wide Ruled
  • Small Grid
  • Medium Grid
  • Large Grid
  • Very Large Grid

That’s right – you might have noticed that there is also a grid rule you can use, just like that graphing paper we had to use back in school!  Ahh the memories!

‘till next time!
TNP ;)

Show a PowerPoint 2007 slide show in a window

Did you ever notice that when you show your PowerPoint 2007 deck that it always shows it as a full screen?

Have you ever wondered if it was possible to show a PowerPoint presentation in a window that you can resize to meet the needs of your presentation?  For example, you might want to demonstrate a product, and have your presentation on the screen at the same time!

Well there is a well hidden command in PowerPoint 2007 which means you can show your deck in a window!  Here is how to do it:

1) Beside the quick access toolbar (in the top left hand corner of the screen – it is the one what has the save, and undo buttons) you will see a little arrow that points down.  Click on that

2) From the menu that appears, click “More Commands…”

3) In the “Choose commands from:” dropdown box, select “All Commands”

4) You will see literally hundreds of commands listed.  Luckily they are all in alphabetical order!  Scroll down until you find one that says “Slide Show in a Window”.  Click on that.

5) Click on the “Add > >” button to add that command to your quick access toolbar

6) Click “OK”


You will notice that there is a brand new button in your quick access toolbar in PowerPoint 2007.  It looks like a presentation screen, with a window in front of it.

Simply click on that button, and your presentation is now delivered through a window instead of full screen!

How easy is that!

‘till next time!
TNP ;)