Civil Engineering Projects
Macro 8: Determine Whether a Workbook Is Already Open
The previous macro automatically opened a workbook based on the user's selection. As we ...
Macro 7: Opening a Specific Workbook Defined by the User
Want to give yourself or your users a quick way to search for and open a file? This ...
Macro 6: Open a Workbook to a Specific Tab
In some situations, it's imperative that your workbook be started on a specific worksheet. With this
...
Macro 5: Unprotect a Worksheet on Workbook Open
If you've distributed workbooks with protected sheets, you likely get the workbooks back with the ...
Macro 3: Saving a Workbook Before Closing
This macro is an excellent way to protect users from inadvertently closing their file before saving. ...
Macro 2: Saving a Workbook
When a Particular Cell Is
Changed
Sometimes, you may be working on data that is so sensitive that you'll want to ...
Macro 1: Creating a New Workbook from Scratch
You may sometimes want or need to create a new workbook in an automated way. For instance, you
...
Taking a Brief Look at Variables
Another concept you will see throughout the macros in this book is the concept of variables. We need to
...
Discovering the Excel Object Model
In Excel, you deal with workbooks, worksheets, and ranges on a daily basis. You likely think of each
of ...
Customizing the VBA Environment
If you're serious about becoming an Excel programmer, you'll spend a lot of time with VBA modules
on your ...
Working with a Code Window
As you become proficient with VBA, you spend lots of time working in Code windows. Macros that
you record are ...
Working in the Visual Basic Editor
The Visual Basic Editor (VBE) is a separate application where you write and edit your VBA macros. You
can't ...
