Microsoft Office Tutorials and References
In Depth Information
Enabling Macros in Excel 2013
Form controls versus ActiveX controls
Although the Form controls and ActiveX controls look similar, they’re quite different:
Form controls are designed specifically for use on a worksheet
ActiveX controls are typically used on Excel UserForms.
As a general rule, you want to use Form controls when working on a worksheet. Why? Form controls
need less overhead, so they perform better, and configuring Form controls is far easier than
configuring their ActiveX counterparts.
Enabling Macros in Excel 2013
With the release of Office 2013, Microsoft introduced significant changes to its Office security model.
One of the most significant changes is the concept of Trusted Documents. Without getting into the
technical minutia, a Trusted Document is essentially a workbook you have deemed safe by enabling
Viewing the new Excel security message
If you open a workbook that contains macros in Excel 2013, you’ll get a message in the form of a
yellow bar under the Ribbon stating that Macros (active content) has, in effect, been disabled.
If you click Enable, the workbook automatically becomes a Trusted Document . This means you will no
longer be prompted to enable the content as long as you open that file on your computer. The idea
is that if you told Excel that you trust a particular workbook by enabling macros, it’s highly likely that
you’ll enable macros each time you open it. Thus Excel remembers that you’ve enabled macros
before and inhibits any further messages about macros (for that workbook).
This is great news for you and your clients. After enabling your macros just one time, they won’t be
annoyed by the constant messages about macros, and you won’t have to worry that your
macroenabled dashboard will fall flat because macros have been disabled.
Setting up trusted locations
If the thought of any macro message coming up (even one time) unnerves you, you can set up a
trusted location for your files. A trusted location is a directory that is deemed a safe zone where only
trusted workbooks are placed. A trusted location allows you and your clients to run a macro-enabled
workbook with no security restrictions as long as the workbook is in that location.
Search JabSto ::

Custom Search