For Excel version 2010 and below, an easy VBA macro can be used to generate a compatible password to “un-protect” a worksheet. The macro that is floating around the internet does not actually...
https://www.kentcalero.com/manually-remove-sheet-protection-from-an-excel-workbook/
If your Microsoft Office products are freezing, lagging or behaving strangely, the issue may be with hardware graphics acceleration. We’ve seen issues involving Windows 8 and Nvidia Graphics c...
https://www.kentcalero.com/microsoft-office-freezing-or-lagging/
This one comes to you compliments of www.extendoffice.com ” The following short VBA code also can help you display all of the hidden sheets at the same time. 1. Hold down the Alt + F11 keys i...
https://www.kentcalero.com/useful-excel-functions-unhide-all-hidden-worksheets/
With Outlook versions before 2010, you were limited to having 1 Exchange Type Account (mailbox) per profile. In this case, adding additional mailboxes was handled exclusively through the “add a...
https://www.kentcalero.com/multiple-exchange-accounts-in-microsoft-outlook/
Normally, the excel substitute() function is limited to finding 1 string and substituting said string for another string. This Excel User Defined Function allows you to substitute multiple sets o...
https://www.kentcalero.com/useful-excel-functions-substitute-multiple-characters/
A user called in today with a Microsoft Word issue, we don’t usually support Microsoft Word but most “issues” end up being very simple fixes. The issue today was that he user was unable to ...
https://www.kentcalero.com/windoworphan-control-obscure-microsoft-word-option/
Are you responsible for multiple exchange (e-mail) mailboxes? Tired of sent items not going into their corresponding sent-box? Here is the solution for Microsoft Outlook Email that you send on be...