Avoid repeated: create a Word macro

Repeated input of the same information in the document after document, always and always... There must be a quicker way, right? You can save Word macros time (and possibly some reason) by to automate repetitive tasks.

Suppose you are a real estate agent. Every time, when you sell a home, you need name and address of the customer, the documents added. Create a macro to automate addition of all contact information of the customer, where whatever you need.

Creating a macro is straightforward and does not require programming skills. You simply say Word when you start and stop recording a series of steps; Type, for example, from at the start a client name, when you are finished. Then Word will all these steps automatically when you click a button or enter a shortcut key, you the macro assigned to the.

Here is a step by step:

1. Go to the view click the macros tab drop - down-list and select record macro.

In the dialog box to record a macro , you're going to call and describe your macro, and then select whether you want to run it on a key or key combination.

2. In the macro name box  dialog box, type your macro a name that contains no spaces, e.g., AdamSmith instead of Adam Smith.

3. The ' Description ' field is for you. In the course of time, you can create dozens of macros and anger might remember what is what. Give a description of you, out helps.

4. In the box store macro in determine whether the macro is running in the current document or all documents. Select the option--to run in all documentsall documents-.

5. Choose, whether you use a link or button, the macro run, by clicking on the button or keyboard symbols. For this exercise, click.

After you click,you can word your button to place add light-the toolbar for quick accessyou can find.

1. In the field of Word options/Quick Access toolbar , click the name of the macro, and click Add to include it on the list of the other commands on the Quick Access toolbar.

 

To ensure that you can identify the button on the toolbar, select a button.

2. Click on the change, and then select a button from the dozens available.

Once you select your button and click on OK, starts the macro is running, that record your keystrokes until you stop recording. For example, I chose the button of a man, wearing a tie, you click on OK, and the macro started, lived in Lincoln, entered Nebraska recording a fictitious client named Adam Smith's address. As I finished typing, I clicked stop recording the macro - drop-down list.

Here is how you can do:

1. Inthe dialog box changebutton , select a button, and then click OK.

2. Click OK again in the Word Options and starts to macros.

3. Lead the actions that you want to include in your macro.

4. Once you have performed the actions, gomacro tab on the viewtab, and then click stop recording.

5. You now see that the macro button appears on the toolbar for quick access. Just click and the same actions that you recorded to happen again, where to put the cursor in a document. They see this button on the toolbar for quick access in all Word documents if you have chosen that they once displayed only in your old.

View the original article here

How to avoid the army 'Death by PowerPoint'

Here is a great article from Wired that you don't want to miss. It talks about Microsoft's Dave Karle, an Army veteran, whose latest mission is, people correctly use PowerPoint in the army and eventually elsewhere, or at least no longer use, to get it wrong.

It is an idea, we here fits perfectly to one of the most important issues, that which the PowerPoint blog (SlideFest an example) have concentrated. As the article States, "..."Karle is not trying to use the army of Microsoft presentation software. PowerPoint is already everywhere within the army - to the chagrin of many officer. Karle's mission is much more difficult: stop the army from using it stupid. "

Or even use, depending on what presents the presenter not PowerPoint. "Use Word sometimes instead of PowerPoint." Sometimes using a whiteboard, "Karle says." "It's all about the tool behind the tool attachment." He holds. "I love that phrase."

You will find the article here: http://www.wired.com/dangerroom/2011/06/microsoft-helps-the-army-avoid-death-by-powerpoint/.

Karle also has his own blog. It's called modern presenter.

--Erik Jensen

View the original article here

To avoid, that the State of global IRibbonUI Ribbon object

In today's post offers Excel MVP Ron de Bruin a solution to a common problem that occurs if you use RibbonX and VBA, customize Ribbon. For more tips and links to Excel add-in the Ron's Web site: http://www.rondebruin.nl/.

It is a common problem when you work with the Ribbon using RibbonX and VBA. Ribbon object (that is initialized when Excel loads the file) can lose the reference to the Ribbon, which is that your code can no longer say mean Excel to update your Ribbon customizations.
There is simply no simple, restore integrated fashion that handle for the Ribbon, if it problems in or with your code. The only way to fix it is close and not very user friendly reopen your workbook.

But MVP Rory Archibald came with a great idea in a post in the Forum MrExcel. In the example in the workbook that you can download on this page (see below) is based on Rory's idea and works in 32-bit Excel 2007 and Excel 2010 32-bit - and 64-bit.

You store the pointer to the IRibbonUI in a cell (or the name or where ever) and it use CopyMemory then get back, if the State is lost.

You can test this sample workbook this method, the Ribbon handle restored if it is lost.

Download: Loss of the Ribbon state.zip.  

Note: decided I me not the workbook code RibbonX to this page add, because, if you work the code in the workbook can see, it is much clearer. If all this is new to you, I suggest that you click on the link below, with my Ribbon page start then.

For more information about customizing the Ribbon, see to change the Ribbon in Excel 2007 or Excel 2010.

--Ron de Bruin

View the original article here

Set text wrap around images and shapes in PowerPoint? Avoid it!

We see a lot of questions about flow as you text in PowerPoint around a picture or shape. And it is not easy (although we article have PowerPoint 2010 and PowerPoint 2007 , which explain, admittedly complicated workarounds to get the wrapping effect).

As difficult and awkward to do it, we would like to see more comments from people who are unhappy as people who say, they find it useful.

But PowerPoint works best if it has less text. Some keywords. Not enough to wrap. This is a problem, the we here on the PowerPoint blog passionate than feel.

If you want to communicate many words, Word is a better bet. Publisher is. You can can create files, read the people at will.

You want to create a presentation, especially when you present the person, less words work so much harder for you especially if you add a picture to.

You need not put everything on a slide, because people who read film be and is not for you to hear. (If you want all available information, when you book the deck or then send it in e-Mail, add it to you. the notes section)

Less on a film set and employs to keep changing films, which often helps the audience. With one or two keywords and a compelling image, the audience gets magic-they find out how these elements want to relate. They hear you. In a presentation, which is a good thing.

I know that nobody likes as you are told with their software. But after a few simple policy-as the entertaining illustrated by Doug Thomas in his Office casual to create better presentationsor Microsoft MVP Stephanie Krieger 12 Tips for creating better presentations - skills to create compelling presentations without ever wrap text in PowerPoint again.

--Erik Jensen

View the original article here