Жанры
Авторы
Контакты
О сайте
Книжные новинки
Популярные книги
Найти
Главная
Авторы
Dick Kusleika
Excel Macros For Dummies
Читать книгу Excel Macros For Dummies - Dick Kusleika - Страница 1
Оглавление
Предыдущая
Следующая
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
...
64
Оглавление
Купить и скачать книгу
Вернуться на страницу книги Excel Macros For Dummies
Оглавление
Страница 1
Страница 2
Excel® Macros For Dummies® To view this book's Cheat Sheet, simply go to
www.dummies.com
and search for “Excel Macros For Dummies Cheat Sheet” in the Search box. Table of Contents
List of Illustrations
Guide
Pages
Страница 7
Страница 8
Страница 9
Macro Fundamentals
Choosing to Use a Macro
Macro Recording Basics
Examining the macro
Editing the macro
Testing the macro
Comparing Absolute and Relative Macro Recording
Recording macros with absolute references
Recording macros with relative references
Understanding Macro Security
Macro-enabled file extensions
Trusted documents
Trusted locations
Storing and Running Macros
Storing macros in your Personal Macro Workbook
Assigning a macro to a button and other form controls
FORM CONTROLS VERSUS ACTIVEX CONTROLS
Placing a macro on the Quick Access Toolbar
Exploring Macro Examples
Building navigation buttons
Dynamically rearranging PivotTable data
Offering one-touch reporting options
Страница 32
Getting Cozy with the Visual Basic Editor
Working in the Visual Basic Editor
The VBE menu bar
The VBE toolbars
The Project Explorer
The Code pane
The Immediate window
Working with the Project Explorer
Adding a new VBA module
Removing a VBA module
Working with a Code Pane
Minimizing and maximizing windows
Getting VBA code into a module
Customizing the VBE
The Editor tab
The Auto Syntax Check option
The Require Variable Declaration option
The Auto List Members option
The Auto Quick Info option
The Auto Data Tips option
The Auto Indent setting
The Drag-and-Drop Text Editing option
The Default to Full Module View option
The Procedure Separator option
The Editor Format tab
The Code Colors option
The Font option
The Size setting
The Margin Indicator Bar option
The General tab
The Docking tab
{buyButton}
Подняться наверх
