Office Solutions

A Brief look at Permissions in Exchange Server and their Impact on Data Security

A judicious use of permissions can go a long way in improving overall data security. Exchange provides its users with Role Based Access Control (RBAC) permissions. This model of permissions is based on predefined permissions. You can grant users these permission rights when you assign them their roles and thus kick start operations in MS Exchange. Assigning permissions to users through defined roles makes operations a lot easier; these roles come with predefined set of permissions, which...

Read more »

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 »