Data theft can be minimised by disabling various menu and right-click features in Excel. We discuss below how to do this using VBA.
It is assumed the reader has the Excel Developer ribbon displayed, and is familiar with the VBA Editor.
The User Interface
Build a worksheet with two buttons and a little data.
This sheet will have its ribbon displayed, and all the right_click functionality that Excel affords.
The sheet is available here.
The VBA Code
There are a variety of...
Read more »
It is useful sometimes to read a worksheet line-by-line and selectively take data from it. An example below shows how to do this.
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 following example manipulates the data by examining each row of email addresses and concatenating them into a single address line. While Excel has built-in Transpose functions, we intend...
Read more »
In the following article, let’s go through the 6 quick and awesome ways to switch between open Word document windows.
Now and then, it’s quite often to conduct multiple tasks at one time. And when it comes to Word, opening several documents at the same time is not unusual. However, living in an age when time is one of our greatest assets, to do things quick and fast is required everywhere. So, a little time squeezed can mean a lot to us. Now let’s take a look at how we can save time by...
Read more »
