Link Worksheet Form Controls with Cells on Protected Worksheets without VBA Macros in Excel

Add to Favorites
Author:

Simple method to use Excel Form Controls and ActiveX Controls and link them to cells on protected worksheets without using VBA or Macros.

This allows you to use formulas and functions based off of the user's input into Form/ActiveX Controls while at the same time protecting the entire worksheet and hiding the linked data so that the user cannot change or break anything in the worksheet

This tutorial combines a couple different tricks in order to effectively hide and protect the linked cells without the need for using any kind of code or VBA, which makes the file much easier to maintain and manage in the long-run and means that you do not have to use a macro-enabled workbook in Excel.

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

Similar Content on TeachExcel
Put Data into a Worksheet using a Macro in Excel
Tutorial: How to input data into cells in a worksheet from a macro. Once you have data in your macro...
Get Data from the Worksheet into a Macro in Excel
Tutorial: Here, you'll learn how to get information from the Excel worksheet into a macro so you can...
Do Something Every so Many Rows with a Macro in Excel
Tutorial: How to have a macro do something on a set interval of rows; for instance, input a value ev...
Break out of or Exit Different Types of Loops in VBA Macros in Excel
Tutorial: How to Exit, End, or Break out of loops in Excel. This tutorial includes breaking out of W...
Find the Next Blank Row with VBA Macros in Excel
Tutorial: Learn how to find the next empty cell in a range in Excel using VBA and Macros.  This met...
Run a Macro from Another Macro in Excel
Tutorial: I will show you how to run a macro from another macro in Excel.  This means that you can...