Excel File Recovery

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 »

How to Utilize the Excel’s Double Click Event

Processes can be simplified for the user in some circumstances by using the Double_click event. This event can call macros, depending on the cursor position in the spreadsheet, and write the information to a database. To take this article to its natural conclusion will require a database and a knowledge on how to connect to, and update,  it. It is assumed the reader has the Developer ribbon displayed, and is familiar with the VBA Editor. If not, please Google Excel Developer Tab or Excel...

Read more »