Tag Archives: Workbooks

All About Dim Statements in VBA

A variable is a named storage location in which you can store information while your macro/program is running.  Each variable has a unique name where the name can identify what type of variable it is by using standard naming conventions.  A variable can contain different

No Thumbnail

VBA Excel Working With Protected Sheets

Jump To: Unprotecting and Protecting the Worksheets Unprotecting and Protecting Workbooks Unprotecting and Protecting the Worksheets: As a VBA programmer you will often have protected sheets where you would like your program to be able to modify but still remain protected from the users. There

No Thumbnail

VBA Excel Working with Multiple Workbooks

If your data is saved on several different files then you are going to have to work with multiple workbooks. You can also download all the codes for this article here. Jump To: Creating Workbooks Opening Workbooks Saving Workbooks Saving Workbooks (Save As) Closing Workbooks