Instructions for Configuring and Opening Excel Workbooks ...
Introductory Econometrics: Using Monte Carlo Simulation with Microsoft Excel®
Humberto Barreto and Frank Howland wabash.edu/econometrics
Properly Configuring Excel:
To make sure that Excel is able to access and run the Visual Basic macros in the workbooks, Security must be properly set.
Step 1: From Excel, execute Tools: Macro: Security
[pic]
At the Security Level tab, make sure that Very High or High are NOT selected. Medium will always give you a warning that the file you are about to open has macros, and then you can decide whether to run the macros (or open the file). Low is (quite reasonably) not recommended because Excel will automatically run all macros with no warning or prompt.
Click the Trusted Publishers tab and make certain both boxes are checked to ensure that installed add-ins will have access to your Visual Basic Projects (i.e., your workbooks).
Security need be set only once because Excel will remember
your settings. With Excel’s Security correctly configured, you
are ready to open the Excel workbooks on this CD and install
add-ins as needed.
Step 2: From Excel, execute File: Open to open a workbook.
When opening a workbook from this CD, always click the “Enable Macros” option.
Do not click Enable Macros for workbooks from other sources unless you are completely confident that the workbook is safe.
To make an add-in available for use (like Excel’s Solver or one in this CD-ROM), execute Tools: Add-ins. Check the desired add-in or click Browse and navigate to it. Click OK when prompted to write it to your hard drive. Do not try to directly open an add-in file (add-ins have .xla extensions as opposed to the normal .xls extension).
To use the files on this CD, simply navigate to the desired folder (by double-clicking it) and double-click on the desired file or open a file from Excel as described in Step 2. Please see the User Guide for more details on the materials available on this CD. The TableofContents.doc file in the Chapters folder has a complete listing of all workbooks on this CD.
When you open a file from the CD, it may be read-only. Execute File: Save As and navigate to a folder on your hard drive or network space to save your work. You may drag the contents of this CD onto your hard drive. Right-clicking on the folder and selecting Properties enables setting a variety of attributes. Click to clear the Read-Only option.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- using sas dde sas macro and excel vba macros to create
- macros for financial applications
- primer in excel vba
- excel vba notes for professionals
- 040 30 a macro for importing multiple excel worksheets
- excel 4 0 macro functions reference
- intro and proper configuration depauw university
- instructions for configuring and opening excel workbooks
- excel advanced course materials
- excel chapter 12 templates styles and macros
Related searches
- nature medicine instructions for authors
- cane walking instructions for patients
- email instructions for beginners
- scientific reports instructions for authors
- zicam instructions for use
- nature instructions for authors
- yahoo email instructions for beginners
- nature journal instructions for authors
- excel formula for find and replace
- tablet instructions for dummies
- instructions for schedule d irs
- instructions for schedule a