article discusses an Excel help tool that allows you to create simple Excel
file has green input fields, which should serve as input navigation as with the
tax office. All other areas are automatically locked by the Excel add-in.
addition, all necessary parameters and variables are stored in a _Setup data
sheet. The system-relevant Excel auxiliary sheets must be named with a
_subtrable and are then automatically hidden completely.
system Excel sheets such as _Setup, data can be stored which should not be
visible to the user at the time of entry.
hides them with the attribute: VeryHidden.
Install Excel Add-In
add-in is located in an Excel file with the file extension .xlam.
contains simple vba-Excel macro code that can be optimized and improved by
All Install in Excel of Excel Addin as .xlam
Developer Tools-> Excel Add-ins->: In the dialog: Add-ins on the button:
the addin, you have to go to the file dialog: Browse to the path with the Excel
addin and select the file: Addin_System.xlam
addins, which were embedded by Excel .xlam files or .xla files, appear
automatically in Excel 2013, 2016 Office365
Ribbonbar-> Add-ins-> Custom Symbol Files
structure of the Excel document you can outsource all system-relevant data in
system sheets. These sheets are named with a _underline and can be hidden
automatically with the addin.
hiding removes all system leaves with the attribute: veryhidden
Addin-> Show (Unlock) all system sheets are displayed again.
or initialization sheets begin with a _colour in the name field
The hidden system
sheets are not directly under Excel sheet-> Show
all sheets are locked when hiding or Lock and only the released input fields
can still be entered.
result, the Excel sheet becomes a pure data input sheet, which is locked
against other changes.
tries to write in a protected cell or change the cell, then comes a message
The cell or diagram that that you want to
change is on a read-only sheet.
To make a change, remove the sheet's
protection. You may be asked to enter a password