Protect VBA

You can protect you complex VBA scripts from modification and copying through the use of password protection. In this post we will demonstrate how to use the standard Excel security to protect you VBA scripts and macros.

Read More »

Workbook Protection

In this post we will demonstrate the use of Workbook Protection and how it can be used to restrict access to your Spreadsheets. This can be combined with Worksheet Protection for further control access to specific information within your workbooks.

Read More »

Protecting Cell Data in Excel

After you have a developed an Excel spreadsheet that is going to be used by others you should consider protecting the spreadsheet to guard against any unplanned changes to formulas and formatting by less experienced users. Excel's Cell Protection feature can provide this functionality ensuring that critical formulas are not inadvertently changed when using the spreadsheet.

Read More »

How to find the last used Cell in a Worksheet

There are a number of options to find the Last Used cell in a worksheet. You can use direct worksheet navigation keys to go to the bottom of column or VBA can be used to determine the last used row in a column. In this post we will describe both methods.

Read More »

Using Names in Excel to save time and effort

you can create a Name for that cell that can be used in the workbook to reference that cell. For example if the worksheet contains Sales Data and the cell in question is the total of sales for all sales staff it may called TotalSales. Then wherever we need to use that value we can refer to the name rather then the specific cell reference.

Read More »

Open a Workbook

The following routine will Open a Workbook and create a reference to it for use in further processing

Read More »