How to Prevent Your Excel Workbook from being Moved or Copied

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 »

2 Ways to Create Different Headers or Footers for Different Parts of Your Word Document

In this article, we will focus on demonstrating you 2 ways to create different headers or footers for different parts of your Word document. When writing a paper or a long essay, we tend to create headers or footers for it. But usually all of them are of the same contents. What if you need to set non-identical headers or footers for odd and even pages? Or what if you have to create non-identical headers or footers for different parts? Without knowing how, such a demand can be an ailing...

Read more »