Pablo Gallardo's Blog
My professional web log about IT, Project Management & SAP
Archive | Office Suites RSS feed for this section

How to remove Password from VBA Project in Excel

Instructions For XLSM files Open the XLSM file with 7-Zip (right click -> 7-Zip -> Open archive). Copy the xl/vbaProject.bas file out of the file (you can drag and drop from 7-Zip), don’t close 7-Zip Open the vbaProject.bas file with HexEdit Search for “DPB=” and replace it with “DPx=” Save the file Copy this file back into 7-Zip […]

Comments { 0 }

Mockups, wireframes, prototypes on Microsoft Visio

Microsoft Visio is globally known as an application that allow users to create diagrams. But it is less known that among this diagramming powerness there is also specific funtionality that allows to create your own mockups, wireframes or prototypes for software development. This functionality currently only available on latest desktop versions (Visio 2019, Office 365) […]

Comments { 0 }

How to Unblock Unsafe Attachments in Microsoft Outlook

When receiving an executable file on your Outlook mailbox, you may find that you cannot download the attached file(s) and that you get this text  ”Outlook blocked access to the following potentially unsafe attachments” instead…   It is possible to get rid of this message just by following the tutorial below.   Source: “How […]

Comments are closed

How to change display language on Microsoft Office 2007

Check these links:

Comments are closed

INDEX and MATCH as alternative VLOOKUP in Excel

VLOOKUP is a very useful and powerful Excel formula. It has however, its limitations: for example, the searched word must be obligatory in the first column of the search matrix. This article provides an alternative to VLOOKUP. The alternative would be to use a combination of the formulas INDEX and MATCH instead. There are plenty […]

Comments { 0 }

How to permanently turn off Track Changes in Microsoft Word

Sometimes it is required that local applications in Windows (i.e., Excel) and SAP client use the same decimal formatting (for example, either dot or comma). Following these steps we will get to align both system, and avoid decimal conversion processes: Check Windows Regional OptionsWindows configuration can be changed / displayed in the following path (Windows […]

Comments { 0 }

How to import mail from Outlook to Thunderbird

I have come out to the need to recover some e-mails that were stored in a .pst file (easily read by Outlook, more difficulty imported to other mail client), so I needed to learn how to import mail from Outlook (2010) to Thunderbird (17). Ensure that Outlook is already displaying the e-mails from .pst file. […]

Comments { 0 }

How to check Outlook Web mail from Mozilla Thunderbird

Some users prefer to use a desktop e-mail client (like Outlook or Mozilla Thunderbird) instead of webmail applications (like Gmail or Outlook web), but sometimes the decision is not in their hands. This would be the case of those employees who were asked to replace the Outlook mail client with Outlook Web mail. However, there […]

Comments { 0 }

How to create a Gantt chart in Excel 2007

Today I had to spend a several minutes just to find a proper tutorial about how to create a Gantt chart in Excel 2007 (most of them concerned only previous versions). When I found Microsoft’s official instructions, it turned out that they where incomplete and incorrect at some point. This video tutorial was the best […]

Comments { 0 }
Política de privacidad