Connecting Technology and Business.

Why Does Not My Macro Run?

Microsoft is paranoid about the security threats that Office files face because of the malign coding or programmes that might get attached to these files. That is the reason why, all files created in MS office - Word, Excel or PowerPoint being dominant - are provided an extra layer of protection.

If there is a macro (automatic VB coding for non-developers) embedded in the file, then, the macro will run immediately after it is created but if you want the macro to run in the subsequent sessions after it was created, then, it has to be saved in a different file format than the default file format. It has to be Saved As a macro enabled file (note the m in the file extensions docm, xlsm and pptm).

If you have a macro that is common for two or more files (or for the application itself), then, you can create this macro in the "Personal macro workbook" in Excel or use the option to save and make it available in All documents in Word and All presentations in PowerPoint. Thereafter, you can run this macro in any file saved in the default file format.

Note: If you are creating a file template with a macro, then, you have to save it as a macro enabled template file which is available as one other option when you choose Save as.

Remove Redundant Data In One Or More Columns

‚ÄčAll of us have faced a situation where there were multiple identical entries in a column of a worksheet and we wanted to hold only one of them in the table's column.

There is an easy way to do this in Excel 2010.

Format the range of cells that you are dealing with as a table. (The range might contain more than one column of information). (You can also do this without formatting the range as a table). Then, when inside the table, click on the Table Tools Design tab and click "Remove duplicates". Check the column from the list provided which contains duplicates. (If you want to check for duplicate entries with respect to two or more columns - i.e., check for duplicates in the first AND the second AND so on at a time - then check the relevant column names). Click OK.

Now we will see Excel displaying how many duplicated rows were removed.

If you are not happy, there is always the Ctrl+Z to undo the duplicate removal.

Email Attachments At One Click

‚ÄčAre you working on a file that has to go as an attachment to an email? You can do this in just one click from any Office 2007 or 2010 application - Word, Excel or PowerPoint.

Look at the Quick Access toolbar at the top of the application window. You can customize this toolbar to show various commands or features that you frequently use which require three of four clicks one after the other to accomplish a task. One such feature is E-mail. Check the box against E-mail and this will become one of the Quick Access commands on the toolbar.

The next time you want to send a file you are currently working, as an attachment, just click this E-mail icon on the Quick Access toolbar. Bingo! A new mail window opens and your file becomes an attachment to the mail.

No need for clicking on the Attachments option in the new mail window

No need to search for the folder in which the file is located

No need to search for the file in the folder

Make sure to save the file with an appropriate name before you click on the E-mail icon - your file can also become an attachment with wierd names like Document1.Docx or Book1.xlsx or Presentation1.pptx.

This is a real timesaver for a lot of users.

Note: You must have an Outlook email profile available in the login that you are working for this to happen.