If you want to send an email without subject, you will definitely receive an Outlook alert. It’s exactly annoying. In response to this issue, this article will introduce you 2 methods to disable the no subject warning.
You must have encountered No subject warning in Outlook. It usually pops up if you intend to send an email without subject. To be honest, this warning is indeed helpful and useful in that some users often forget to enter the email subject. But for those who exactly would like...
Read more »
How often do we get dates in spreadsheets supplied to us as 12.26.2016, or 26/12/2016 (UK format), only to be told the date is invalid or there's no month 26? This article explores fixing dates with VBA, using TRIM, LEFT, RIGHT and MID functions.
The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window".
The xlsm in this exercise can be downloaded here.
Not Our Problem!
The...
Read more »
In this article, there are 4 easy tips for you to change the color of comment balloons or texts in your Word document.
By and large, the color of comment balloons in document is randomly assigned by Word according to the editing author. Similarly, the comment text color is by default set in black. Nevertheless, we still can apply some tricks to change the default color.
Tip 1: Apply Custom Color for Comment Balloons
It’s a popular knowledge that Word distributes color to comment balloons...
Read more »
