Guide to Converting Excel 2003 Macros to Excel 2010When you decide to replaceMicrosoftExcel 2003 with Excel 2010, you may not give a second thought to your macros until you try to use them. However, with a little preparation, you can easily convert your Excel 2003 macros to Excel 2010, including those in your personal workbook.Backing Up MacrosThe first thing you need to do is backup your Excel 2003 macros. Under most circumstances, the macros stored in individual workbooks, meaning those you use in single spreadsheets or workbooks, can be converted easily without any extra work. However, there are times when the only way to make the macros work correctly is by manually copying and pasting them into Excel 2010.Open any workbooks where your Excel 2003 macros are stored. Open the Visual Basic for Applications editor. Select theToolsmenu, chooseMacrosand selectVisual Basic Editor. Choose your macro's name. Copy all code for each individual macro. OpenNotepadand paste the contents of each macro into a new Notepad document. Name the Notepad documents as the macro name. If you have multiple macros stored in a single workbook, copy them all into the same Notepad document for easily retrieval later.Notepad can be opened by selectingAll Programsfrom the start menu, choosingAccessoriesand selectingNotepad.Now that you've backed up your single macros, it's time to backup your personal workbook. You only need to do this if you've stored macros which can be used universally in all Excel spreadsheets and workbooks. By default, the Personal.xls workbook is stored at C:\Program Files\Microsoft Office\OFFICE11\XLSTART. The directory will be different if you chose a different installation location when you installed Excel 2003. Copy thePersonal.xlsfile to a new location, such as your desktop. To prevent any possible macro loss, copy any macros stored in this file to a Notepad document as well.Convert Excel 2003 Macros to Excel 2010Now that all your macros are backed up, it's time to install Excel 2010. Once Excel 2010 has been installed successfully, open one of your Excel 2003 workbooks in Excel 2010. Try to run your macros. If they run without any problems, your macros converted successfully. Go to theFilemenu and selectSave As. Choose the Excel 2010 format to complete the conversion.If you receive an error message or nothing happens, try one of the following methods:Trust Center- Go toFile, selectOptionsand chooseTrust Center. PressTrust Center Settingsnear the center of the screen. SelectMacro Settingson the left side of the trust center window. Choose to eitherEnable all macrosorDisable all macros with notification. With the first option, all macros will run regardless of the creator. The second option provides you with a notification which lets you enable or disable macros whenever you open a workbook.SelectTrusted Locationson the left side of the trust center window and selectAdd new location. Add the location where you store your Excel workbooks to the trusted locations list. This will prevent your macros from being blocked due to their location.Copy and Paste- Open the Visual Basic Editor in Excel 2010. Select theDevelopertab and chooseVisual Basic. Select the sheet or workbook you want to add the macro to. Copy and paste the desired macros from your Notepad documents. Save your changes and close the Visual Basic editor. Run your macros to test them.Convert Your Personal WorkbookBefore you create any new macros in your Excel 2010 personal workbook, open thePersonal.xlsworkbook you backed up earlier in Excel 2010. Go toFileand selectSave As. PressBrowseand choose the following directory as your storage location: C:\Program Files\Microsoft Office\OFFICE14\XLSTART. The directory may vary based on the installation location you chose when you installed Excel 2010. However, be sure to name the workbookPersonal, save it using the default Excel 2010 extension and store it in the XLSTART folder. This will allow you to use all your saved macros in Excel 2010 workbooks and spreadsheets like you did in Excel 2003.http://voices.yahoo.com/guide-converting-excel-2003-macros-excel-2010-7706248.html

Converting Word 2003 macros to Word 2010 (or 2007)Normally, I write about things that make many people, including my boss, head explode. But today, I want to talk about Macros, not the C++ Macros, but rather the down to earth macros that the hardworking paralegals, administrative assistants or secretaries might use.Why? My sister-in-law, Kathy, was visiting this week, and just before she left to return to the lovely land of Seattle, she ask a question:The law firm I work for upgraded to Word 2010 and I no longer have my macros that I used in the previous version of Office (which I think was Office 2003, but could have been Office XP), what happened to them? Is it Office 2010 fault?The answer is pretty simple: Usually when a system is upgraded a proposal is written between the IT consulting firm and the customer, especially if it is for a law firm. Often, the normal.dot template is not part of the contract between the IT consulting firm and the law firm, or any firm for that matter. However, the line workers, in this case the paralegals, often use recorded macros for efficiency purposes, but lawyers usually dont use these macros. After a number of years using Office XP, these paralegals build up a significant amount of macros that they are used to having.When the new Office 2010 is put into place the normal.dot from Office XP or Office 2003 is not used to build the new normal.dotx. Unfortunate since it is very easy to do, of course some macros will not translate because they may use features unique to Office 2003 or Office XP. But most will.Here is one way to do (make sure to test that everything works before committing to this as a consultant):Change the name of the Office 2003 or XP to normal1.docBuild Office 2010Open Office 2010On the ribbon, select View, Macros, View Macro, select or click the Organize button, then the dialog box below will show up:

In the box on the left select normal1.doc, select the macros you need to move to the new normal.Close and that will do it, the macros will now be available for you to use in your documents.So, you might ask, what about autocorrect? Well I will describe how to move your autocorrect from an earlier version to a later version in a later blog post.Finally, why hasnt Microsoft clearly documented this procedure? I have no idea, it appears to be an oversight that needs to be addressed by the Office team, frankly, I could not easily find the answer on office.com, so why should you? And the user experience is that the end users blame Microsoft for the upgrades, etc. when the ease of fixing that dissatisfaction could easily be accomplished.After all, Administrative assistance, secretaries, paralegals, etc. really make use of this kind of thing and they need to be taken care of as well.http://blogs.msdn.com/b/devschool/archive/2011/05/01/converting-word-2003-macros-to-word-2010-or-2007.aspx

What's new in Microsoft Outlook 2010Microsoft Outlook 2010 includes new features and capabilities to help you stay connected with people and bettermanage your time and information.Expanded ribbonFirst introduced in Microsoft Office Outlook 2007, the ribbon is part of the Microsoft Office Fluent user interface. It is designed to help you quickly find the commands that you need to complete a task. Commands are organized in logical groups that are collected together under tabs. In Outlook 2010, the ribbon has replaced the former menus in the main Outlook window. In addition, the ribbon can be customized to include custom tabs that you can personalize to better match your work style.

More room to manage your accountMany Outlook settings that are not directly related to creating or managing Outlook items, such as print commands and account management options, are now in the Microsoft Office Backstage view. ClickFileto manage your accounts, set up rules and Automatic Replies, and find other behind-the-scenes options.See more of your messagesAn improved conversation view is now available when you work with your messages. This view improves tracking and managing related messages, regardless of the folder that contains the messages. You can see the complete course of the conversation, including your responses, find the most recent responses, and more easily determine the message most important to you. You can also easily categorize or ignore a complete conversation. For more information, seeIntroduction to Conversation View.

Process and file your messages fasterQuick Steps Turn commands and procedures that you use most often into one click. You can customize the default Quick Steps, and create your own buttons that combine your frequent actions. The Quick Steps gallery includes buttons for one-click file and flag, sending messages to your team, and other popular commands. For more information, seeAutomate common or repetitive tasks with Quick Steps.

Meeting Reply Scheduling a meeting is as easy as replying to the message. While reading a message, you can schedule a meeting with all the message recipients with the newMeeting Replycommand. All the messages recipients are added to a new a meeting request in one click. For more information, seeRespond to an e-mail message with a meeting request.Instant Search improvements Outlook 2007 introduced Instant Search. In Outlook 2010 it is easier to narrow your search results by using criteria such as sender, subject keywords, and other information such as the presence of attachments. The Search Tools contextual tab includes a set of filters that efficiently focus your search to isolate the items that you want. For more information, seeFind a message or item by using Instant Search.

Reduce the noise in your InboxIgnore Conversation If a conversation is no longer relevant to you, you can prevent additional responses from appearing in your Inbox. TheIgnorecommand moves the whole Conversation and any future messages that arrive in the Conversation to theDeleted Itemsfolder. For more information, seeIgnore Conversation.

Clean Up Conversations When a message contains all the previous messages in the Conversation, you can clickClean Upto eliminate the other redundant messages. For example, as people reply to a Conversation, the response is at the top and the previous messages in the Conversation are below. Instead of reviewing each message, keep only the most recent that includes the whole Conversation. For more information, seeUse Conversation Clean Up to eliminate redundant messages.

Work smarter and more efficiently with messagesMailTips Outlook 2010 includes MailTips, which help you avoid common, but potentially costly or embarrassing mistakes. MailTips alerts can be triggered by actions including clickingReply Allto a large recipient list, sending sensitive information to someone outside your organization, or sending a message to someone who is out of office. For more information, seeTurn on or off MailTips.

Forgotten subjects When you clickSendon a message that does not have a subject, a message appears to confirm that no subject was intentional.

Auto-Complete List improvements It is easier to remove a name from the Auto-Complete List suggestions, and when you are using a Microsoft Exchange Server account, your Auto-Complete List is available from any computer that you use Outlook with your Exchange account. For more information, seeDelete a name from the Auto-Complete list.

Resize attached photos An option is available to resize large attached pictures. For more information, seeReduce the size of pictures and attachments.

Include screen shot Sharing what you see on your screen is easy with the new Include screen shot command. Select all or any part of your computer screen and include a snapshot of it in a message.

More spell checking Spell checking works in more places. This includes subject lines of messages, tasks, and meeting requests.Expanded delivery information When you use a Microsoft Exchange Server account, you can review detailed delivery information both for outgoing and incoming messages.Get the calendar big pictureMeeting Suggestions Introduced in Outlook 2007, Meeting Suggestions now appears when you create a meeting request. Schedules for attendees are analyzed and the best time is suggested, based on everyone's availability.

Calendar Groups Quickly see the calendars of people you frequently work with. Select the members one time, then use the Calendar Group every time that you want view those same calendars. Calendar Groups can also include resources, such as conference rooms. This is a great way to find available conference rooms in your building. For more information, seeCreate, view, or delete a calendar group.

Schedule View Whether you use the new Calendar Groups, or manually select multiple calendars to review, the new Schedule View can help take some guesswork out arranging meetings. Individual, resource, or Calendar Group calendars appear in a horizontal view to quickly discover the best time to meet.

Quick View When you receive a meeting request, Quick View helps you better understand how a meeting request affects your calendar. When creating or responding to a meeting request, a calendar snapshot appears in the meeting request. You can instantly review any conflicts or adjacent items on your calendar without ever leaving the meeting request.

Work with all your accounts in OutlookMultiple Exchange accounts Outlook 2010 supports multiple Exchange accounts within an Outlook profile.IMAP improvements Deleting messages in an IMAP e-mail account resembles other e-mail account types. When messages are deleted, they are moved to aDeleted Itemsfolder. Marking messages for deletion and purging is no longer necessary.Stay on top of your tasksTo-Do Bar The To-Do Bar has been improved based on customer requests. In Outlook 2010 there is better access to all-day appointments and events. Additional improvements include visual indicators for conflicts and unanswered meeting requests, day separators, and convenient drag and drop resizing to see more of what you want when you want it. For more information, seeChange the size or contents of the To-Do Bar.Save your informationNew data file name When you save Outlook information on your computer a data file is used. In previous versions of Outlook these files were named Personal Folders files (.pst) and Offline Folder files (.ost). They are now namedOutlook Data File (.pst)andoffline Outlook Data File (.ost). For more information, seeCreate a file to save your information.Easier access to your Outlook Data Files (.pst and .ost) All earlier versions of Outlook saved your data files in Personal Folders Files (.pst) and Offline Folders Files (.ost) in a hidden folder on your computer. In Outlook 2010, any new data file that you create is saved, by default, in the Documents\My Outlook Files folder. This makes it easier for you to back up your Outlook data and to locate and copy the data file to a new computer. For more information, seeCreate a file to save your information.Stay connectedOutlook Social Connector The new Outlook Social Connector (OSC) connects you to the social and business networks you use, including Microsoft SharePoint, Windows Live, and other popular third-party sites. You can get more information and stay in touch with the people in your network without leaving Outlook. For more information, seeIntroduction to the Outlook Social Connector.

Quick Contacts Get faster access to your contacts including instant messaging and presence indicators with Quick Contacts without leaving the mail view. With the newFind a Contactbox on the ribbon, you can start to type the name of the person you are looking for and get instant results including multiple ways to connect to the person including instant messaging, phone, mail, and meeting scheduling. When Microsoft Lync integration is enabled, you can search your Global Address List (GAL) and Contacts using a type-ahead search that shows user photos, title, and availability in addition to names.Hierarchal Address Book You can pick recipients for messages, meeting requests, and task assignments by browsing an organization tree view in the Outlook Address Book.Unified Messaging improvementsVoice mail transcripts Voice Mail Preview provides a speech to text transcript of the message left on your voice mail.

Secure voice mail Protected voice mail helps to secure and limit voice mail to only their intended recipients.Additional improvementsView zoom control Zoom in or out of your mail or calendar views with the new zoom slider control at the bottom of the window.

Quota Information In the new Backstage view, your account information includes a visual representation of how much space is left in your mailbox.

Navigation Pane All commands and views that were previously in theNavigation Panehave moved to the ribbon. The order of the folders was also changed to make it easier to find common default folders, specifically the Inbox and Deleted Items. Some headers and icons were removed to streamline the appearance of the Navigation Pane.Extensibility Outlook 2010 delivers developer requested features that enable application-specific customization of the Outlook user interface. In addition to improved programmability of the Outlook UI, the Outlook object model provides support for new and expanded features in the product such as Conversations and Mobile Items.Command line switches Additional command line switches have been added for deployment and troubleshooting. For more information, seeCommand-line switches for Microsoft Outlook 2010.64-bit support Outlook 2010 is available in both a 32- and 64-bit version.http://office.microsoft.com/en-us/outlook-help/what-s-new-in-microsoft-outlook-2010-HA010354412.aspx#top

Basic tasks in Outlook 2010Here are some basic tasks that you can do in Microsoft Outlook 2010.If what you are looking for isnt listed here, use the search box above.

In this article What is Outlook? Add an e-mail account Create a new e-mail message Forward or reply to an e-mail message Add an attachment to an e-mail message Open or save an e-mail message attachment Open an attachment Save an attachment Add an e-mail signature to messages Create a signature Add a signature Create a calendar appointment Schedule a meeting with other people Set a reminder For appointments or meetings For e-mail messages, contacts, and tasks Create a contact Create a task Create a note Print an e-mail message, contact, calendar item, or taskWhat is Outlook?Microsoft Outlook 2010 offers premium business and personal e-mail management tools to more than 500 million Microsoft Office users worldwide. With the release of Outlook 2010, you get a richer set of experiences to meet your communication needs at work, home, and school.From a redesigned look to advanced e-mail organization, search, communication and social networking features, Outlook 2010 provides you with a world-class experience to stay productive and in touch with your personal and business networks.TOP OF PAGEAdd an e-mail accountBefore you can send and receive e-mail messages using Outlook 2010, you must add and configure an e-mail account. If you have used an earlier version of Microsoft Outlook on the same computer where you have installed Outlook 2010, your account settings are automatically imported.If you are new to Outlook or are installing Outlook 2010 on a new computer, the Auto Account Setup feature automatically starts and helps you configure account settings for your e-mail accounts. This setup requires only your name, e-mail address, and password. If your e-mail account cannot be automatically configured, you must enter the required additional information manually.1. Click theFiletab.2. UnderAccount Information, and clickAdd Account.

For more information, seeAdd or remove an e-mail account.NOTE To add an Outlook.com account (formerly Hotmail), seeUse an Outlook.com account in Outlook.TOP OF PAGECreate a new e-mail messageOutlook 2010 enables you to communicate with one or more recipients with a rich set of features and customizations. InMail, on theHometab, in theNewgroup, clickNew E-mail.

Keyboard shortcut To create an e-mail message, press CTRL+SHIFT+M.For more information, seeCreate an e-mail message.TOP OF PAGEForward or reply to an e-mail message On theHomeorMessagetab, in theRespondgroup, clickReply,Reply All, orForward.

NOTE The name of the tab depends on whether the message is selected in the message list or opened in its own window.To remove a name from theToandCclines, click the name and then press DELETE. To add a recipient, click in theTo,CcorBccbox and enter the recipient.For more information, seeReply to or forward an e-mail message.TOP OF PAGEAdd an attachment to an e-mail messageFiles can be attached to an e-mail message. Also, other Outlook items, such as messages, contacts, or tasks can be included with messages that you send.1. Create a message, or for an existing message, clickReply,Reply All, orForward.2. In the message window, on theMessagetab, in theIncludegroup, clickAttach File.

For more information, seeAttach a file or other item to an e-mail message.TOP OF PAGEOpen or save an e-mail message attachmentYou can open an attachment from theReading Pane, or from an open message. After opening and viewing an attachment, you may choose to save it to a disk drive. If a message has more than one attachment, you can save multiple attachments as a group or one at a time.Open an attachment Double-click the attachment.Save an attachment1. Click the attachment in the Reading Pane or the open message.2. On theAttachmentstab, in theActionsgroup, clickSave As. You can also right-click the attachment, and then clickSave As.

For more information, seeOpen and save attachments.TOP OF PAGEAdd an e-mail signature to messagesYou can create personalized signatures for your e-mail messages that include text, images, yourElectronic Business Card, a logo, or even an image of your handwritten signature.Create a signature1. Open a new message. On theMessagetab, in theIncludegroup, clickSignature, and then clickSignatures.

2. On theE-mail Signaturetab, clickNew.Add a signature In a new message, on theMessagetab, in theIncludegroup, clickSignature, and then click the signature that you want.

For more information, seeCreate and add an e-mail message signature.TOP OF PAGECreate a calendar appointmentAppointments are activities that you schedule in your calendar that do not involve inviting other people or reserving resources. InCalendar, on theHometab, in theNewgroup, clickNew Appointment. Alternately, you can right-click a time block in your calendar grid, and then clickNew Appointment.

Keyboard shortcut To create an appointment, press CTRL+SHIFT+A.For more information, seeSchedule an appointment.TOP OF PAGESchedule a meeting with other peopleA meeting is an appointment that includes other people and can include resources such as conference rooms. Responses to your meeting requests appear in yourInbox. InCalendar, on theHometab, in theNewgroup, clickNew Meeting.

Keyboard shortcut To create a new meeting request from any folder in Outlook, press CTRL+SHIFT+Q.For more information, seeSchedule a meeting with other people.TOP OF PAGESet a reminderYou can set or remove reminders for a variety of items, including e-mail messages, appointments, and contacts.For appointments or meetingsIn an open item, on theAppointmentorMeetingtab, in theOptionsgroup, in theReminderdrop-down list, select the amount of time before the appointment or meeting when you want the reminder to appear. To turn a reminder off, selectNone.For e-mail messages, contacts, and tasks On theHometab, in theTagsgroup, clickFollow Up, and then clickAdd Reminder.

TIP You can quickly flag e-mail messages as to-do items by using reminders. Right-click the Flag Status column in the message list. Or if you have the message open, on theMessagetab, in theTrackinggroup, clickFollow Up, and then clickAdd Reminder.For more information, seeSet or remove reminders.TOP OF PAGECreate a contactContacts can be as simple as a name and e-mail address, or include additional detailed information such as street address, multiple phone numbers, a picture, birthdays, and any other information that relates to the contact. InContacts, on theHometab, in theNewgroup, clickNew Contact.

Keyboard shortcut To create a contact from any folder in Outlook, press CTRL+SHIFT+C.For more information, seeCreate or add a contact.TOP OF PAGECreate a taskMany people keep a list of things to do on paper, in a spreadsheet, or with a combination of paper and electronic methods. In Microsoft Outlook you can combine various lists into one, get reminders and track task progress. InTasks, on theHometab, in theNewgroup, clickNew Task.

Keyboard shortcut To create a new task, press CTRL+SHIFT+K.For more information, seeCreate tasks and to-do items.TOP OF PAGECreate a noteNotes are the electronic equivalent of paper sticky notes. Use notes to jot down questions, ideas, reminders, and anything you would write on paper. InNotes, in theNewgroup, and clickNew Note.

Keyboard shortcut To create a note, press CTRL+SHIFT+N.For more information, seeCreate a note.TOP OF PAGEPrint an e-mail message, contact, calendar item, or taskYou can print individual items, such as e-mail messages, contacts, or calendar items, or larger views, such as calendars, address books, or content lists of Mail folders.The procedure for printing is the same in Mail, Calendar, or any other folders in Microsoft Outlook all printing settings and functions are found in the Backstage view. Click theFiletab to open the Backstage view.1. Click an item or folder in Outlook that you want to print.2. Click theFiletab.3. ClickPrint.For more information, seePrint items in Outlook.http://office.microsoft.com/en-us/outlook-help/basic-tasks-in-outlook-2010-HA101829999.aspx#top

Habilitar o deshabilitar macros en archivos de OfficeUna macro est compuesta por una serie de comandos que puede usar para automatizar una tarea repetitiva, y se puede ejecutar cuando haya que realizar la tarea. Este artculo contiene informacin acerca de los riesgos relacionados con el trabajo con macros, y le permitir aprender a habilitar o deshabilitar macros en el Centro de confianza.En este artculo Habilitar macros cuando aparece la barra de mensajes Habilitar macros en la vista Backstage Habilitar macros para una sesin cuando aparece la advertencia de seguridad Cambiar la configuracin de las macros en el Centro de confianza Explicacin de la configuracin de macros Qu es una macro, quin las crea y cul es el riesgo para la seguridad?Habilitar macros cuando aparece la barra de mensajesCuando abre un archivo con macros, aparece laBarra de mensajesamarilla con un icono de escudo y el botnHabilitar contenido. Si sabe que la macro o macros proceden de un origen confiable, use las siguientes instrucciones: En laBarra de mensajes, haga clic enHabilitar contenido.Se abrir un archivo que es undocumento confiable.La imagen siguiente es un ejemplo de la barra de mensajes cuando hay macros en el archivo.

VOLVER AL PRINCIPIOHabilitar macros en la vista BackstageOtro mtodo para habilitar macros en un archivo es mediante la vista Backstage de Microsoft Office, la que aparece al hacer clic en la pestaaArchivo, cuando aparece la barra de mensajes amarilla.1. Haga clic en la pestaaArchivo.2. En el reaAdvertencia de seguridad, haga clic enHabilitar contenido.3. EnHabilitar todo el contenido, haga clic enHabilitar siempre el contenido activo del documento.El archivo pasa a ser undocumento confiable.La imagen siguiente es un ejemplo deHabilita siempre el contenido activo del documentoy deOpciones avanzadas.

La imagen siguiente es un ejemplo ms extenso de las opciones deHabilitar contenido.

VOLVER AL PRINCIPIOHabilitar macros para una sesin cuando aparece la advertencia de seguridadUtilice las siguientes instrucciones para habilitar macros mientras el archivo est abierto. Cuando cierre el archivo y, a continuacin, vuelva a abrirlo, la advertencia aparecer de nuevo.1. Haga clic en la pestaaArchivo.2. En el reaAdvertencia de seguridad, haga clic enHabilitar contenido.3. SeleccioneOpciones avanzadas.4. En el cuadro de dilogoOpciones de seguridad de Microsoft Office, haga clic enHabilitar contenido para esta sesinpara cada macro.5. Haga clic enAceptar.La imagen siguiente es un ejemplo del cuadro de dilogoOpciones de seguridadpara una macro.

VOLVER AL PRINCIPIOCambiar la configuracin de las macros en el Centro de confianzaLa configuracin de las macros se encuentra en el Centro de confianza. Sin embargo, si trabaja en una organizacin, es posible que el administrador del sistema haya cambiado la configuracin predeterminada para que nadie pueda modificarla.IMPORTANTEAl cambiar la configuracin de las macros en el Centro de confianza, solo cambia en el programa de Office que est usando. La configuracin de la macro no cambia para todos los programas de Office.1. Haga clic en la pestaaArchivo.2. Haga clic enOpciones.3. Haga clic enCentro de confianzay, a continuacin, haga clic enConfiguracin del Centro de confianza.4. EnCentro de confianza, haga clic enConfiguracin de macros.5. Realice las selecciones oportunas.6. Haga clic enAceptar.La imagen siguiente es el reaConfiguracin de macrosdel Centro de confianza.

Utilice la informacin en la siguiente seccin para obtener ms informacin acerca de la configuracin de las macros.VOLVER AL PRINCIPIOExplicacin de la configuracin de macros Deshabilitar todas las macros sin notificacin Las macros y las alertas de seguridad sobre las macros estn deshabilitadas. Deshabilitar todas las macros con notificacin Las macros estn deshabilitadas, pero se mostrarn alertas de seguridad si hay macros presentes. Habilite las macros de una en una. Deshabilitar todas las macros excepto las firmadas digitalmente Las macros estn deshabilitadas, pero se mostrarn alertas de seguridad en caso de que haya macros. Sin embargo, si la macro cuenta con una firma digital emitida por un editor de confianza, se ejecutar la macro si ha especificado su confianza en el editor. De lo contrario, se le pedir que habilite la macro firmada y que determine su confianza en el editor. Habilitar todas las macros (no se recomienda, se podra ejecutar cdigo peligroso) Se ejecutan todas las macros. Esta configuracin hace que su equipo sea vulnerable a posibles cdigos perjudiciales. Confiar en el acceso al modelo de objeto de proyectos de VBA Permita o deshabilite el acceso programtico al modelo de objeto deMicrosoft Visual Basic para Aplicaciones (VBA)de un cliente de automatizacin. Esta opcin de seguridad sirve para que un cdigo escrito automatice un programa de Office y manipule el entorno y modelo de objeto de VBA. Esta es una configuracin que se adapta al usuario y a la aplicacin, y no permite el acceso de forma predeterminada, de modo que no permite que programas no autorizados creen fcilmente un cdigo perjudicial que se autorreplique. Para que los clientes de automatizacin puedan obtener acceso al modelo de objeto de VBA, el usuario que ejecute el cdigo debe otorgar dicho acceso. Para habilitar el acceso, active la casilla de verificacin.NOTAMicrosoft Publisher y Access no tienen la opcinConfiar en el acceso al modelo de objeto de proyectos de VBA.VOLVER AL PRINCIPIOQu es una macro, quin las crea y cul es el riesgo para la seguridad?Las macros automatizan tareas usadas frecuentemente para ahorrar tiempo de pulsaciones de tecla y acciones del mouse. Muchas se crearon conMicrosoft Visual Basic para Aplicaciones (VBA)y son diseadas por programadores de software. Sin embargo, algunas macros pueden implicar un posible riesgo de seguridad. Una persona malintencionada, tambin conocida como pirata informtico, puede introducir una macro destructiva en un archivo que puede propagar un virus en su equipo o en la red de su organizacin.http://office.microsoft.com/es-mx/word-help/habilitar-o-deshabilitar-macros-en-archivos-de-office-HA010354316.aspx#top

12+ Tips and Tricks to Work Faster in Microsoft OutlookLove it or hate it, Microsoft Outlook is still the de facto email client at many offices. It's been a while since we took a look at good old Outlook, so here are some of our favorite tricks well worth revisiting to increase your productivity in this all-in-one email, calendar, tasks, and notes program.PThe instructions and details in this post are based on Outlook 2010, but they should work with both earlier and later versions of Outlook, except where otherwise noted.PGeneral ShortcutsPThe shortcuts below work across the whole program, so you can get more done whether you're reading emails or adding meeting events to your calendar.P1. Learn Outlook's keyboard shortcuts.LikeMicrosoft Word,Excel, and other Office apps, Outlook has unique keyboard shortcuts so you don't have to waste time moving your mouse around or drilling down through menus. Learn the ones you use most and you'll speed through your Outlook tasks. MakeUseOf has a handyOutlook keyboard shortcuts cheat sheetyou can download or print out. Among the most useful:PRELATED

Learn All the Microsoft Word Keyboard Shortcuts with This Printable CheatsheetMicrosoft Word offers manyat least 247keyboard shortcuts to speed up your document creation workflow. If you don't know all of them yet, grabRead

See Excel Keyboard Shortcuts for PC and Mac Side-by-SideExcel training site Exceljet offers this handy page of about 200 keyboard shortcuts for both PC and Mac.Read Ctrl+R: reply to emailP Alt+R: reply to all in email or switch to the work week calendar viewP Alt+W: forward email or switch to the weekly calendar viewP Ctrl+M: F9 to Send/Receive allP Alt+S: Send emailP Ctrl+G: open the "Go to date" dialog to jump to any date in the calendarPYou can alsoswitch between mail, calendar, contacts, and other items in the navigation paneby hitting Ctrl + [the place number of the item], e.g.:1P

RELATED

Quick Steps Looks Like Office 2010's Killer FeatureMicrosoft's Office 2010 has rolled out to trusted testers, and among the screenshots coming back, nothing seems so promising as the Quick StepsRead2. Take advantage of Outlook's Quick Steps.For those unfamiliar, Quick Steps isthe killer featureMicrosoft introduced with Outlook 2010. They're shortcuts to any multi-step action you can think of, such as moving emails to a specific folder and marking them as read or forwarding an email to your team and flagging it at the same time. It makes short work of repetitive tasks, and you cancreate your own Quick Step actions.P

3. Create a new item from your clipboard.Hat tip to fellow Lifehacker Walter Glenn for this tip (and others in this piece):PCopy any text to your clipboard, then in Outlook press Ctrl-V. Outlook creates a new message (or note or whatever item, depending on the folder you're viewing) with the text already pasted.PSo instead of creating a new item in Outlook, and then copying and pasting text in, you do both in one step.PEmail ShortcutsPEven though Gmail and other webmail services are quite capable, Outlook is no slouch when it comes to sorting, filtering, categorizing, and otherwise wrangling your inbox to your needs.PRELATED

Turn Off All Your AlertsExcept the Immediately Actionable OnesYour life is packed full of all types of alerts. You get emails, text messages, push notifications, and phone calls all the time begging for yourRead4. Limit desktop notifications to only the most important emails.It's terribly distracting to constantly be told "you've got mail!" but you still want toget notified for the most important alerts. In Outlook, set desktop notifications only for those VIP messages. Canadian legal magazine Slaw offersa detailed tutorialfor how to do this, but, essentially, first you'll turn off all desktop alerts under the Mail Options, then create an Outlook rule to display alerts for messages from specific people sent only to you. For example:P

PP5. Flag messagesfast.With a message or two selected, jut hit the insert key to toggle the flag on or mark it done.P6. Get emails that aren't sent directly to you out of your inbox.In an old post (still worth looking at if you're using Outlook), Scott Hanselman detailshis GTD organization method for Outlook. One of the best tips is to use a special "Inbox CC" folder to gather all the emails that aren't sent directly to you; that way, the inbox is focused on only the most important emails. To set this up, go to Rules > New Rules. Then click the "Advanced Options" button. In the Rules Wizard, select "where my name is not in the To box" and then in the next screen, "move it to the specified folder." (Alternatively, set up a VIP email folder and move "emails sent only to me" into that special folder.)PPRELATED

How to Use Text Expansion to Save Yourself Hours of Typing Every WeekIn a regular day, most of us type the same things over and over again, wasting an enormous amount of time in the process. Why not let your computerRead7. Use email templates to never write the same email twice.Tired of sounding like a broken record? For those emails you send often, such as requests for information or reminders of due invoices, save the email as a template via File > Save As > Outlook template. Then, to use the template, go to New Items > Choose Form and look in your "User Templates in File System" to browse for the template you saved. Or, even quicker, double-click the OFT file from Windows Explorer to create a new message from that template. You can alsouse text expansionto accomplish this across any program on your computer.P8. Create search folders for your most important emails.What are your most frequently accessed emails? Maybe they're emails from your boss or certain subjects (now where's that TPS report?). For any search you perform often, just save the search for quick access. Click on Search Folders in the left navigation menu, select "New Search Folder," and then either use the wizards or manually customize the search to your specifications.P

9. Quickly save emails as files.If you want to save certain emails for posterity, you have a few methods at your disposal. While you can individually save any email through the File > Save As... menu (options: text, HTML, Outlook Message format or .msg, HTML, .mht), it's far faster to save emails by dragging them to the desktop or Windows Explorer. This will save them in Outlook's proprietary .msg format, with the subject as the file name.PYou could also use VBA scripts likethisandtheseto automatically (or semi-automatically) save emails to your local hard drive as individual messages, freeing them from the .PST or .OST file Outlook keeps them in.PTasks, Calendar, Notes, and JournalPOutlook isn't just an email client. It's a full-fledged Personal Information Manager. Having everything in one place has its advantages, but there are still ways to use all these features more effectively.P10. Group tasks by custom priority.If you want to use Outlook as your to-do manager too, MSDN's JD Meier suggeststhis organizational structure: In addition to adding a start date to each of your tasks, add a custom priority field (such as P0, P1, and P2). Then you can group your tasks by that custom field so you can see at a glance which ones to work on at the right time. For example:P

RELATED

Work More Productively on Your Own by Playing "Workstation Popcorn"Productivity is a challenge when you're working for yourself or working remotely with no one watching over you. Joel Runyon offers a somewhatReadThis method might also work well with productivity techniques like working on tasks in batchessuch as theWorkstation Popcornway of working productively from homeor if you want to organize your tasks by the amount of time they take.P11. Use natural language to create a calendar event.Don't waste time scrolling through the monthly date picker to find the exact date for an appointment or meeting. In the date field, type naturally "Independence Day," "three days from tomorrow," and so on.P12. Save Outlook notes, events, and any other item to the desktop for quick access.It's not just emails you can save to your computer outside of Outlook: calendar events, notes, contacts, and everything else can be dragged to the desktop or a Windows folder as individual items for quick access later. Double-click the itemeven if Outlook isn't openand it'll open right away in Outlook.PBonus (for Outlook 2010 and earlier): Use Outlook as an automatic time tracking tool.This one's been deprecated in Office 2013, but if you have an earlier version of Outlook, you can use the Journal toautomatically log your tasks, time, Office documents usage, and so on. You have to click on the left navigation pane's "More" button to find the Journal icon and then enable the Journal to track messages from specific contacts, meeting requests, and time spend in other office programs.P

You'll then see a timeline and detailed log of all these events, which is great for those of us who have to keep timesheets, invoice clients, or just want to jog their memories about where the time really went.PThese are all just scratching the surface of Outlook's capabilities. Loaded with options and features, as well asVBA scripts you can install or write yourself, Outlook is a powerful tool for organizing your daily life. For more tips and tricks, see our previouscollection of Outlook tipsor share your favorites here.http://lifehacker.com/12-tips-and-tricks-to-work-faster-in-microsoft-outlook-1540483009